Sorry for first message it was not utf8 so it had charachter problems here is the true characters
--------------------------------------------- Hello, I have an "SQL_Latin1_General_CP1_CI_AS" database. But till now some coders entered Turkish characters into it with Coldfusion 5. Table columns are varchar and text. When looked into tables with Enterprise manager the turkish characters are seen wrong. Because Turkish characters are written to the database with conversiton they converted the Turkish characters to their "SQL_Latin1_General_CP1_CI_AS" equvalents for example they converted ı ( short I, not i ) to ý . now when a create a database with "SQL_Latin1_General_CP1_CI_AS" collation and hit "ı" it writes to db "ý" i fill a column with these types of characters and then i run this script (column MMMMMM is varchar(50)) ALTER DATABASE XXXXX COLLATE Turkish_CI_AS ALTER TABLE ZZZZZ ALTER COLUMN MMMMMM nvarchar(50) ALTER TABLE ZZZZZ ALTER COLUMN MMMMMM nvarchar(50) COLLATE Turkish_CI_AS but when i do this sql server puts "?" for "ý". So tried ALTER DATABASE XXXXX COLLATE Turkish_CI_AS ALTER TABLE ZZZZZ ALTER COLUMN MMMMMM varchar(50) COLLATE Turkish_CI_AS ALTER TABLE ZZZZZ ALTER COLUMN MMMMMM nvarchar(50) this time SQL server puts "ý" for "ý". Seems ok ? But when i use CFMX 7.0 to select data from table and write it to screen it shows "ý" not "ı". Would you recommed any script or tool which can do this conversation ? Best Regards... Ergun KOCAK www.websiteci.com/ergun ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2228 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
