Setting the locale for ADO.NET sessions

• ADO.NET applications use a UTF-16 character set encoding and are responsible for converting any non-UTF-16 encoded data to UTF-16. The same cautions as for ODBC apply if this encoding is violated.

• The ADO.NET driver converts UTF-16 data to UTF-8 when passing to the OpenText™ Analytics Database server and converts data sent by the database server from UTF-8 to UTF-16.

• ADO.NET applications should set the correct server session locale by executing the SET LOCALE TO command in order to get expected collation and string functions behavior on the server.

• If there is no default session locale at the database level, ADO.NET applications need to set the correct server session locale by executing the SET LOCALE TO command in order to get expected collation and string functions behavior on the server. See the SET LOCALE command.