Missing characters in MySQL

[Andrew Mason]

Ok, :) these types of problems aren't too hard to fix, it's a simple 
configuration problem somewhere, you just have to identify where the actual 
problem is. Is the mac web server/database the same actual box as the linux 
dbserver/webserver?


On Wednesday 22 December 2004 3:34 pm, 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