Missing characters in MySQL

[Niels Riis Kristensen]

Hi

Nah, that is not so. And this is why:

I have two identical databases on a Mac OSC server and a YDL 4.0 
server. All the characters are there in both databases.

Search from Mac to Mac: All the characters shows.
Search from Mac to Linux: No special characters shows.
Search from Linux to Linux: No special characters shows.
Search from Linux to Mac: No special characters shows.

So you see, it is all the Linux configurations that are faulty and 
since the Mac can display characters from Mac but can't display 
characters from Linux, then wrong regionalization is not the problem.

Furthermore I have made a clean english install with time zone set to 
mine (copenhagen) AND a clean danish install with full danish 
localization, and none displayed the characters.

Niels Riis Kristensen
(nrk at nrk-gruppen.dk)

NRK Group
- Electronic Music Engraving
- Webhosting
- Dynamic Web design
- E-Lists hosting

---
Send money safely over the Internet!
Click this link for more information: 
https://www.paypal.com/refer/pal=EAJLSE5TQELFC

On 22/12-2004, at 13.36, Andrew Mason wrote:

> This isn't a MySQL/PHP issue..this just your browser not being set up
> correctly for your region :)
>
> On Wednesday 22 December 2004 12:19 pm, Niels Riis Kristensen wrote:
>> Hi
>>
>> A have a friend that finally convinced me to switch server platform
>> from Mac OSX to YDL. But I have a major problem with MySQL (or PHP)
>> that, if not fixed, will make me switch back as soon as I can finish
>> the OSX install!
>>
>> I live in Denmark, Europe and in my country we have a few special
>> characters that are special to our language. These characters are off
>> course richly represented in my databases, some of which are pretty
>> large (over 10.000 entries). My problem is, that these characters do
>> not display when I make a php request from the websites. When I check
>> the fields in PhpMyAdmin or Webmin the characters are there alright 
>> and
>> the internal character set is the same as my Mac OSX server
>> (ISO-8859-1). What is really worrying my, is that if I make let's say 
>> a
>> search from YDL's mozilla browser to my Mac OSX server the characters
>> doesn't show! Off course they show in my duplicate Mac search on the
>> same database on the same machine.
>>
>> This is a major hurdle for me and if I can't get this to work this
>> would be my shortest participation in a mail list ever!
>>
>> Can anyone please help me?
>>
>>
>> Niels Riis Kristensen
>> (nrk at nrk-gruppen.dk)
>>
>> NRK Group
>> - Electronic Music Engraving
>> - Webhosting
>> - Dynamic Web design
>> - E-Lists hosting
>>
>> ---
>> Send money safely over the Internet!
>> Click this link for more information:
>> https://www.paypal.com/refer/pal=EAJLSE5TQELFC
>>
>> _______________________________________________
>> yellowdog-newbie mailing list
>> yellowdog-newbie at lists.terrasoftsolutions.com
>> http://lists.terrasoftsolutions.com/mailman/listinfo/yellowdog-newbie
> _______________________________________________
> yellowdog-newbie mailing list
> yellowdog-newbie at lists.terrasoftsolutions.com
> http://lists.terrasoftsolutions.com/mailman/listinfo/yellowdog-newbie
>