0

sql server 2005 encoding problem

view story
linux-howto

http://serverfault.com – Ive got text file with utf-8 encoding with more then 2k lines of insert command. Now I would like to execute it as a sql script to insert data into database. There is greek text with which there are problems. After inserting there are only ? characters, no greek letters. sample insert statement is presented below: INSERT INTO myDB.[MC_LIST] ([id], [data], [author], [created], [language], [type_name], [position]) VALUES ('2086','<data><id>1</id><language>gr</language><szonelinkdest>/products/how-does-nioxin-works-page.aspx</szonelinkdest> (HowTos)