Cannot change client encoding of MySQL database! *Urgent*

Scriptcase 8 Bugs
#1

I cannot change client encoding of my database from UTF8 (to Latin1). All my Swedish letters are now scrambeled! After pressing save the setting jumps back to UTF8. Need to get this fixed NOW! Where is this setting stored, can I change it manually?

SC 8.0.020
Thank you!

EDIT:
Restored a backup for now…

#2

You can do this (change the collation) within SC’s Database Builder tool (you need to change it at the database / table level). Or via the phpmyadmin tool

#3

Really!? The Collation of the database is the same as always, the only thing that has changed is the “Client encoding”. And all letters (Swedish) are now scrambled. I would rather be able to change the setting back in SC Prod…

#4

Did you try to set the permissions of the _lib folder temporarily to 777?

jsb

#5

Hello,

What is your Client Encoding of your database?

What is your Client Encoding of your tables?

Are your using the same Client Encoding for same options?

For final, what is your Charset of your Project (language).

Thank you!

#6

Hi Thomas

What is your Client Encoding of your database?
utf8_general_ci

What is your Client Encoding of your tables?
utf8_general_ci

Are your using the same Client Encoding for same options?
The only way I could get the Swedish letters to work was by using Latin1 as client encoding in the Collation settings In SC… Otherwise yes!

For final, what is your Charset of your Project (language).
ISO-8859-1

Thank you!

#7

[QUOTE=jsbinca;29760]Did you try to set the permissions of the _lib folder temporarily to 777?

jsb[/QUOTE]

I will give it a try, thank you!