Forum Moderators: coopster

Message Too Old, No Replies

PHP and ODBC - Extended ASCII Problem

         

logon2future

4:07 am on Sep 12, 2007 (gmt 0)

10+ Year Member



I am using php and odbc to manipulate data in a Microsoft Access Database File (.mdb)
My input is extended ascii code
Example: ̺Á¸Äº
but when i submit it....i am getting different characters in the database.
Why is this happening?
Does Microsoft Access database file support extended ascii code?

phparion

5:04 am on Sep 12, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



you might want to use

Content-Type: text/html; charset=utf-n8

in your php page

logon2future

5:56 am on Sep 12, 2007 (gmt 0)

10+ Year Member



when i use this
Content-Type: text/html; charset=utf-n8
i get correct encoding when i echo the text
but same problem with Database

i submit it as ¶·¸¹º»¼½
displayed as ¶·¸¹º»¼½
but it is stored in the database as ¶·¸¹º»¼½

phparion

11:12 am on Sep 12, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



I do not know much about MS Access and I guess there will be some solution to this. However a work around could be to save characters with their codes and then convert them back while reading them using

php chr function [us3.php.net]