CODEWITHSUNDEEP
phppythonsqlunicode
Alessandro
Alessandro

Reputation: 89

How to insert UNICODE characters to SQL db?

I want to build an universal database in which I will keep data from multiple countries so I will need to work with the UNICODE charset.

I need a little help in order to figure out which is the best way to work with stuff like that and how my queries will be affected ( some sql example queries from php/python for basic stuff like insert/update/select would also be great)

Thank you.

Upvotes: 0

Views: 2645

Answers (2)

Steve
Steve

Reputation: 11973

just put a N infront of the string, something like INSERT INTO MYTABLE VALUES(N"xxx") and make sure your column type is nvarchar

Upvotes: 1

geggleto
geggleto

Reputation: 2625

there is nothing special you need to do.

with php you can do... query("SET NAMES utf8");

Upvotes: 0

Related Questions