Missing characters in MySQL

Wed Dec 22 08:48:10 MST 2004

SUCCES!!!!

I got a crazy idea and went in to force apache a bit. Changed the first  
language to danish (was czech), set LanguagePriority so da was first,  
and the changed AddDefaultCharset to ISO-8859-1. And it worked!! What  
it was that actually hit the button I do not know. Main thing is that  
it works. 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 16.34, Niels Riis Kristensen wrote:

> Hi
>
> Seems I was a little too quick there. What happened was that I used a  
> browser FROM Linux to make a search on my Mac database, and that  
> turned out alright. I then copied the database to the linux mysql  
> server and tried it the other way around, that is FROM Mac TO Linux  
> and the problem was there again. When I tried to make the search FROM  
> Linux TO Linux, then I couldn't see the characters. Instead there was  
> little black squares.
>
> I am beginning to give up now!
>
> 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 15.07, Niels Riis Kristensen wrote:
>
>> 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
>>>
>>
>> _______________________________________________
>> 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
>