RE: [sqr-users] Special Characters

[Bob Stone <bstone@fastenal.com>]

I'm sure the ordering goes down to the ASCII where the special o is listed
after the regular o's.  although I'm not sure how sqr might handle that.
with your function are you ordering by last name with the special chars
before the do translate or are you translating first and ordering after?

I think you have to make your ó look like an o while you order it, and then
back to the ó for display.  Perhaps you could have a non-special char name
variable that would list Gómez as Gomez, then order it and print the actual
name?  

bob stone

-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of
Miller, Danika
Sent: Thursday, July 22, 2004 2:56 PM
To: 'sqr-users@sqrug.org'
Subject: [sqr-users] Special Characters


Has anyone worked with special characters before?

 

I have a last name of Gómez Suarez and a last name of Gutiérrez Roa.  When I
order by last name Gutierrez Roa comes first???  

Any ideas??

 

I have the following code in my program that translates special characters:

 

   do translate-characters($final_name, $final_name-fmt)

 

 

 

 

Please help!!!

 

 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users