• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Storing accented characters in mysql db

#2
[eluser]walterblaurock[/eluser]
One method would be to replace the characters with their numeric codes. A list of such codes can be found here: http://www.december.com/html/spec/codes.html

Doing this will ensure compatibility both with your database and with your viewers' browsers.

I am really not sure of the best way to go about doing this, as in the past I have simple written functions to remove accents (e.g. turn é into e).

Perhaps you can do some kind of replace, where it would take é and replace it with &#thecode;. Assuming you only do this one (when inserting the data), the overhead required by such a function (which arguably wouldnt be that much) wouldn't become an issue, unless you are adding wines by the boatload.

I hope someone else has a better answer for you. Best of luck!


Messages In This Thread
Storing accented characters in mysql db - by El Forum - 07-09-2008, 01:43 PM
Storing accented characters in mysql db - by El Forum - 07-10-2008, 01:10 AM
Storing accented characters in mysql db - by El Forum - 07-10-2008, 03:20 AM
Storing accented characters in mysql db - by El Forum - 07-10-2008, 07:12 AM
Storing accented characters in mysql db - by El Forum - 07-10-2008, 08:24 AM
Storing accented characters in mysql db - by El Forum - 07-10-2008, 08:34 AM
Storing accented characters in mysql db - by El Forum - 07-10-2008, 08:37 AM
Storing accented characters in mysql db - by El Forum - 07-10-2008, 09:32 AM
Storing accented characters in mysql db - by El Forum - 07-10-2008, 09:41 AM
Storing accented characters in mysql db - by El Forum - 07-11-2008, 03:14 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.