ASE Database forum - change insensitive

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

change insensitive

2005-10-27, 8:21 am

is there any parameter that i need to change in order to use UTF-8 case
insensitive? I already got data in database. Will my data safe if I change
to case insensitive. How to change to case insensitive?

mpeppler@peppler.org

2005-10-27, 8:21 am

> is there any parameter that i need to change in order to
> use UTF-8 case insensitive? I already got data in
> database. Will my data safe if I change to case
> insensitive. How to change to case insensitive?

You use the sqlloc (or sqllocres) command. This lets you
change the charset and the sort order. The sort order is
what determines the case sensitivity of the server.

The data should be safe, although you may have to rebuild
indexes to get things to work correctly.

Remember that when you change the server to case-insensitive
*everything* in the server becomes case-insensitive (both
data and table/column/proc names).

Michael

Sponsored Links