Re: Encoding problem...

[Ted Ashton]

Hi many thanks for reply. Here is a specific examples:


EXAMPLE 1

Character as displayed on local web page: ç (c with a squiggle under it)
Character as appears in local database: ç (Sequel Pro)

After a mysqldump (inspecting the raw .sql file)
Character appears as: ç

After uploading the dumped file via scp and processing via gzip as detailed in my initial post.
Character as displayed on remote web page: �
Character as appears in remote database: ç


EXAMPLE 2

Word as displayed on local web page: НА ГЛАВНУЮ
Word as appears in local database: На главную

After a mysqldump (inspecting the raw .sql file)
Word appears as: На главную

After uploading the dumped file via scp and processing via gzip as detailed in my initial post.
Word as displayed on remote web page: ?? ???????
Word as appears in remote database: На главную


Cheers,

Chris