Reputation: 89
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
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
Reputation: 2625
there is nothing special you need to do.
with php you can do... query("SET NAMES utf8");
Upvotes: 0