RE: [PHP] order by what?

2009-06-11 Thread Jay Blanchard
[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

Re: [PHP] order by what?

2009-06-11 Thread PJ
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 the

RE: [PHP] order by what?

2009-06-11 Thread Jay Blanchard
[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 first

Re: [PHP] order by what?

2009-06-11 Thread Robin Vickery
2009/6/11 PJ 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 using mysql, the order is governed by the collation

Re: [PHP] order by what?

2009-06-11 Thread PJ
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 in your

Re: [PHP] order by what?

2009-06-11 Thread PJ
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 your database?

Re: [PHP] order by what?

2009-06-11 Thread PJ
Robin Vickery wrote: 2009/6/11 PJ af.gour...@videotron.ca 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.

Re: [PHP] order by what?

2009-06-11 Thread Andrew Ballard
On Thu, Jun 11, 2009 at 11:27 AM, PJaf.gour...@videotron.ca wrote: Robin Vickery wrote: 2009/6/11 PJ af.gour...@videotron.ca 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

Re: [PHP] order by what?

2009-06-11 Thread PJ
Robin Vickery wrote: 2009/6/11 PJ af.gour...@videotron.ca 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.

Re: [PHP] order by what?

2009-06-11 Thread Per Jessen
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 Eacute; 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

Re: [PHP] order by what?

2009-06-11 Thread Eddie Drapkin
On Thu, Jun 11, 2009 at 11:35 AM, PJ af.gour...@videotron.ca wrote: Robin Vickery wrote: 2009/6/11 PJ af.gour...@videotron.ca mailto:af.gour...@videotron.ca How can order by be forced to order alphabetically and ignore accents without stripping the accents for printout? This

Re: [PHP] order by what?

2009-06-11 Thread Robin Vickery
2009/6/11 PJ af.gour...@videotron.ca Robin Vickery wrote: 2009/6/11 PJ af.gour...@videotron.ca 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