Re: [PHP] order by what?

2009/6/11 PJ > Robin Vickery wrote: > > > > > > 2009/6/11 PJ mailto:af.gour...@videotron.ca>> > > > > How can order by be forced to order alphabetically and ignore accents > > without stripping the accents for printout? This is a problem for > both > > caps & normal letters. > > > > >

Re: [PHP] order by what?

On Thu, Jun 11, 2009 at 11:35 AM, PJ wrote: > Robin Vickery wrote: > > > > > > 2009/6/11 PJ mailto:af.gour...@videotron.ca>> > > > > How can order by be forced to order alphabetically and ignore accents > > without stripping the accents for printout? This is a problem for > both > > c

Re: [PHP] order by what?

PJ wrote: > PJ wrote: > There are some options which all need some sort of adjustment. > If , e.g. É is used in the db instead of É the output onscreen > is a little black diamond with a quesion mark inside. The order is > correct, but the diamond is not acceptable... obviously, one cannot > expec

Re: [PHP] order by what?

Robin Vickery wrote: > > > 2009/6/11 PJ mailto:af.gour...@videotron.ca>> > > How can order by be forced to order alphabetically and ignore accents > without stripping the accents for printout? This is a problem for both > caps & normal letters. > > > Depends on the database. > > If you'

Re: [PHP] order by what?

On Thu, Jun 11, 2009 at 11:27 AM, PJ wrote: > Robin Vickery wrote: >> >> >> 2009/6/11 PJ mailto:af.gour...@videotron.ca>> >> >>     How can order by be forced to order alphabetically and ignore accents >>     without stripping the accents for printout? This is a problem for both >>     caps & norma

Re: [PHP] order by what?

Robin Vickery wrote: > > > 2009/6/11 PJ mailto:af.gour...@videotron.ca>> > > How can order by be forced to order alphabetically and ignore accents > without stripping the accents for printout? This is a problem for both > caps & normal letters. > > > Depends on the database. > > If you'

Re: [PHP] order by what?

Jay Blanchard wrote: > [snip] > >> [snip] >> How can order by be forced to order alphabetically and ignore accents >> without stripping the accents for printout? This is a problem for both >> caps & normal letters. >> [/snip] >> >> Definitely an SQL question. What character set are you using in

Re: [PHP] order by what?

PJ wrote: > Jay Blanchard wrote: > >> [snip] >> How can order by be forced to order alphabetically and ignore accents >> without stripping the accents for printout? This is a problem for both >> caps & normal letters. >> [/snip] >> >> Definitely an SQL question. What character set are you using

Re: [PHP] order by what?

2009/6/11 PJ > How can order by be forced to order alphabetically and ignore accents > without stripping the accents for printout? This is a problem for both > caps & normal letters. Depends on the database. If you're using mysql, the order is governed by the collation used. To get the order y

RE: [PHP] order by what?

[snip] > [snip] > How can order by be forced to order alphabetically and ignore accents > without stripping the accents for printout? This is a problem for both > caps & normal letters. > [/snip] > > Definitely an SQL question. What character set are you using in your > database? Is the accent the

Re: [PHP] order by what?

Jay Blanchard wrote: > [snip] > How can order by be forced to order alphabetically and ignore accents > without stripping the accents for printout? This is a problem for both > caps & normal letters. > [/snip] > > Definitely an SQL question. What character set are you using in your > database? Is t

RE: [PHP] order by what?

[snip] How can order by be forced to order alphabetically and ignore accents without stripping the accents for printout? This is a problem for both caps & normal letters. [/snip] Definitely an SQL question. What character set are you using in your database? Is the accent the first character of the