Skip to main content
Dani Szwarc
Dani Szwarc
Inspiring
October 13, 2008
Question

French characters from DB

  • October 13, 2008
  • 3 replies
  • 564 views
Hello people. I'm working on a site that is in French. All of the static text reads ok with its accents and special French characters, But when I pull text from the database (mySQL) it shows weird characters.

This happens when working on the hosting server. However, in my local environment works ok. I'll check the properties on both dbs (local and remote) and they are the same.

Could someone help please?
This topic has been closed for replies.

3 replies

N
Newsgroup_User
Inspiring
October 14, 2008
DaniFusionWeb wrote:
> However, apparently the problem was on the server side and they fixed it. I
> asked them to tell me what was exactly the issue since I'll be developing more
> sites in French, and I would like to avoid it.

glad to hear.

could have been the db encoding (it doesn't default to utf-8), the driver (ie
used ODBC instead of JDBC), or most likely forgot the mysql jdbc URL parameters.
Dani Szwarc
Dani SzwarcAuthor
Inspiring
October 13, 2008
Hello Paul. It is CF 8, UTF-8, MySQL 5.0.51b.
I don't know the driver.

However, apparently the problem was on the server side and they fixed it. I asked them to tell me what was exactly the issue since I'll be developing more sites in French, and I would like to avoid it.

Thanks again
N
Newsgroup_User
Inspiring
October 13, 2008
DaniFusionWeb wrote:
> Hello people. I'm working on a site that is in French. All of the static text
> reads ok with its accents and special French characters, But when I pull text
> from the database (mySQL) it shows weird characters.

what version of cf? what encoding? what db version? what db driver?
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices