Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is the Default JDBC Character Encoding

I'm developing a Coldfusion app and have seen that I can't insert certain characters into the database. I believe that I can change the JDBC connection string to enable unicode encoding.

However, I would like to know what the default encoding that JDBC uses so I can say what character set is currently safe to use. I can't seem to find information on what the default is anywhere. Does anyone know the default?

Edit:

What it is, while the database is all set for unicode (i can directly insert unicode characters with no problem with SQl using my MySQL client), if i try to insert data from Coldfusion it seems it can't handle the unicode chracters, so it seems the default connection string it uses (we're not specifying one yet) is not unicode compatible

like image 504
dVyper Avatar asked Mar 11 '26 00:03

dVyper


1 Answers

MySQL default encoding is latin1

For applications that store data using the default MySQL character set and collation (latin1, latin1_swedish_ci)

like image 90
user7294900 Avatar answered Mar 12 '26 14:03

user7294900



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!