Missing characters in MySQL

Wed Dec 22 07:07:02 MST 2004

I took a chance and tried the FULL danish install (takes a while!) and  
that worked! AND the httpd.conf had all the languages listed. Thanks  
for the input. I will now try and make a smaller installation, since  
this is to be a dedicated server. Thanks for all your help!

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 14.15, Andrew Mason wrote:

> On Wednesday 22 December 2004 1:04 pm, Niels Riis Kristensen wrote:
>> If i make a php request mb_internal_encoding() it returns ISO-8859-1,
>> and in my Mac httpd.conf all the languages needed are listed. I have  
>> to
>> wait with the Linux configuration since I am trying yet another  
>> install
>> combination of YDL. Will be back with the httpd.conf values then.
> ok. I'd say that the most likely problem is just that apache is  
> configured
> without the extra languages.
>>
>>
>>
>> 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.55, Andrew Mason wrote:
>>> On Wednesday 22 December 2004 12:42 pm, Niels Riis Kristensen wrote:
>>> Did you check the apache config to see what character set its
>>> using...or what
>>> character sets are available
>>>
>>>> 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
>>>>
>>>> _______________________________________________
>>>> 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
>>
>> _______________________________________________
>> 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
>