[progress Communities] [progress Openedge Abl] Forum Post: Re: Utf-8 Encoding Doubt

  • Thread starter Thread starter Garry Hall
  • Start date Start date
Status
Not open for further replies.
G

Garry Hall

Guest
Further to Aidan's response: It is not possible to define your own collation for a UTF-8 database. You have BASIC and the ICU collations. Since OE 11.1, you have a larger choice of locale-specific collations from which to choose, which would hopefully meet your needs. Definitely test before moving to UTF-8, especially queries with non-ASCII data. A word of caution with changing -cpstream: this defines the default codepage used by the client when importing and exporting data, unless it is overridden in the code. If you are importing files with non-ASCII characters, then you will need to be careful to change the code to import from the expected encoding. If this is your development environment you are changing, -cpstream is also used for your source code, so if you have non-ASCII characters in your source, they will be treated incorrectly. A best practice is to avoid non-ASCII characters in source code.

Continue reading...
 
Status
Not open for further replies.
Back
Top