SQL Server install using SQL_Latin1_General_CP1_CI

[Gary W.]

Hi

We're moving to a central repo.  Has anyone had experience with Unicode or non-English (i.e. first nations) using this collation setting?

I'm used to utf8.

thanks
gary

[skiwi]

We use Latin1_General_CI_AS. This works well for the unicode points we wish to represent, e.g. [ch257][ch275][ch299][ch333][ch363]

However there is a (apparently unreproducible at Sparx end) bug that stops us entering these characters - can't insert a character with a macron (e.g. [ch257]) into a note field, but can into the name (or alias or keyword) field
I understand something similar has been encountered by Vietnamese users.

See for example
Typing non-english in Note of Element
Pasting Unicode fails

PS the bulletin board can't find [ch257] either