Scout7 (3/11/2009)
I still current have everything set to the database default, which is as follows;Windows Collation - Latin1_General
Dictionary Sort - Accent Sensitive.
This is working fine for most of main languages as previously stated but something is terribly wrong when I store Hindi which made me think about the collation. I do not want to change anything if I can help it but I do not know how else to fix it? :blink:
Collation does not affect the way the data is stored, it only really affects the way character fields are sorted and compared to each other.
As long as you are using unicode columns, and insert the data using the leading 'N' for unicode , then the data should store without any issues.