Missing characters in MySQL

[Andrew Mason]

On Wednesday 22 December 2004 3:48 pm, Niels Riis Kristensen wrote:
> 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.
Heh, i'm pretty sure that was my second suggestion :)

>>>>> Did you check the apache config to see what character set its
>>>>> using...or what
>>>>> character sets are available?


> 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
>
> _______________________________________________
> yellowdog-newbie mailing list
> yellowdog-newbie at lists.terrasoftsolutions.com
> http://lists.terrasoftsolutions.com/mailman/listinfo/yellowdog-newbie