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.
just put a N infront of the string, something like INSERT INTO MYTABLE VALUES(N"xxx") and make sure your column type is nvarchar
How to insert UNICODE characters to SQL db?