John Jaabæk wrote:

> Seems like I'm getting towards my goal. Thanks Aage.
> I was using standard Win1251. Is it possible to change this character

setting

> after the database has been made or do I have to make a new one. Asking
> before trying and making a shit out of everything.

I haven't used Win1251 - maybe you can get it to work?
You might get away with creating new fields with correct (explicitly
declared) character set and/or collation, and pump data over, dropping
fields and changing names. I'd rather not - you'll probably
meet dependencies that will make this a tedious route.

Otherwise, you'll just have to define a new database with the preferred
default character set, use a script with metadata to recreate everything
(possibly with a collation for relevant fields), and pump data.


--
Aage J.