Missing characters in MySQL

[Niels Riis Kristensen]

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
>