client_encoding does not change in Production env !!!

Scriptcase 8 Discussion
#1

Hi

I change client_encoding option to utf8 in Edit connection and I save but it doesn’t change it ???
DBMS type is MYSQLPDO
my sc verison is v0.35

Thanks for your helps
Nac

#2

[QUOTE=nacyil;35158]Hi

I change client_encoding option to utf8 in Edit connection and I save but it doesn’t change it ???
DBMS type is MYSQLPDO
my sc verison is v0.35

Thanks for your helps
Nac[/QUOTE]

What do you mean, the setting is not saved, or ignored or?
Encoding can be frustrating as the php environment, database AND the connection needs to be configured right.

#3

Hello Albert

It’s ignored !!! actually client_encoding is on ‘latin1’ I don’t know why , I changed to ‘utf8’ after saving I edit my connection and it remained on ‘latin1’

Thanks for answering

#4

Any idea ???

#5

Actually no, the only thing I can think of that the issue is not on your connection, but on your database itself or your application. There are 3 things involved here. You define your database for encoding, you define your php and you need to define your database connection (ie. pdo) with the correct encoding. They have to match.

#6

I understand Albert, I will check that …

Thanks

#7

Sonu-Exchange is delighted to publicize exclusive online currency exchange services in addition to launching a good and competitive rates of exchange.