FN-FORUM: Norwegian, PHP, MSSQL and ADOdb..
date posted 7th January 2005 18:20
It's a match made in.. well, hell, frankly.
Not my choice of platforms, but basically the mix we have is:
PHP (4)
Apache
ADOdb
odbtp
MSSQL
All was working reasonably well, ish, until I introduced ADOdb into the
mix..
Basically - using just odbtp and PHP's native DB functions, Norwegian
characters such as ΓΈ (character 0248) get saved into the database just
fine..
Using ADOdb they get turned into question marks - '?' (in case you can't
remember what one of those is ;))..
Now it can't be the database layer, or odbtp since that works OK in
isolation.. And the PHP appears to be getting the characters from the
posted form input OK, again because it works OK with odbtp etc..
So it's got to be something in ADOdb (or PHP I suppose, one of the
character set/string handling flags?) - does anyone have any clues,
hints, tips? Other than "don't use the combination you're using" ;)
I'd have been better off using Asp.Net, I know, but hindsight is a
wonderful thing.. and it's a bit late to change now - I'm going to
Norway on the 15th for a week and a bit to finish and install!
Heeeeeeeelp, my google-fu has been weak today..
Aaron
