Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
If you're seeing those characters, it could be because you're not saving them as Unicode, or because you're not retrieving them as Unicode. Try each of those things separately. Look at SQL Server directly using SQL Server Management Console or whatever it's called nowadays, and run a query to fetch them. If they're still showing up as question marks, that indicates you're not saving them as Unicode. Otherwise, you're retrieving and/or displaying them in a way that doesn't support Unicode.
If you're not saving them as Unicode, check your SQL Server data source to make sure that the Unicode box is checked under "Advanced Settings" if I recall correctly. That's the most likely problem, I think. See how that works and let us know.
Dave Watts, Eidolon LLC
Copy link to clipboard
Copied
Thanks for the guidance.
While trying directly from SQL Server Management Console window, the special characters are saved to table
column correctly.But while trying to insert using cf code, ie reading the special character text from a csv file
and importing to sql table,it is not getting saved properly.
Tried with above mentioned unicode settings from cf admin datasource advance settings area, restarted both cf service and system,still saving incorrectly.
Please advise
Copy link to clipboard
Copied
You also need to set the character encoding to UTF-8 so the characters coming in do not get stripped.
In the application.cfc add
Copy link to clipboard
Copied
Ensure that your ColdFusion application uses UTF-8 encoding. One way to do so is as follows:
Does that solve the problem?