Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Support to search portuguese caracters Expand / Collapse
Author
Message
Posted Wednesday, August 19, 2009 5:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 11, 2012 10:26 AM
Points: 4, Visits: 22
Hi,

Have you used the Irony library (Irony.dll) like it is in http://irony.codeplex.com/, or have you made same changes?

I am trying to look in Irony code to incorporate portuguese caracters (not suported until now), but when I try to run you code with Irony.dll from
http://irony.codeplex.com gives some error.

Thanks & Regards,
Rui
Post #773385
Posted Wednesday, August 19, 2009 9:01 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, November 13, 2014 2:52 PM
Points: 3,428, Visits: 14,451
Portuguese is standard Latin alphabet western European language that you can support by using System.Text.Encoding in .NET and using either Portuguese Windows collation so you can separate Portugal Portuguese from either Brazilian or Angolan. That is going to VS2005/8 Advanced save as and save you code as Portuguese.

It helps if you start with translated text so it is just simple encoding and collation, in .NET 3.5 most known languages and text encoding formats are supported by default. Post again if you still need help.


Kind regards,
Gift Peddie
Post #773615
Posted Wednesday, August 19, 2009 11:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 11, 2012 10:26 AM
Points: 4, Visits: 22
Gift Peddie (8/19/2009)
Portuguese is standard Latin alphabet western European language that you can support by using System.Text.Encoding in .NET and using either Portuguese Windows collation so you can separate Portugal Portuguese from either Brazilian or Angolan. That is going to VS2005/8 Advanced save as and save you code as Portuguese.

It helps if you start with translated text so it is just simple encoding and collation, in .NET 3.5 most known languages and text encoding formats are supported by default. Post again if you still need help.

Hi Gift,
I am using the Windows-1252 code page that includes Portuguese characters. But when I try to search a word with an Portuguese character appears a error message saying that the character are not valid.
Regards,
Rui
Post #773779
Posted Wednesday, August 19, 2009 12:07 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, November 13, 2014 2:52 PM
Points: 3,428, Visits: 14,451
If you are storing more than Portuguese in one column then you may need Nvarchar definition of your text columns data type and then using Portuguese collation on either table level or column level. You could also add it in your T-SQL code. Here is the System.Text.Encoding page and the SQL Server Windows collation page.

http://msdn.microsoft.com/en-us/library/system.text.encoding.aspx

http://msdn.microsoft.com/en-us/library/ms143508.aspx





Kind regards,
Gift Peddie
Post #773799
Posted Wednesday, August 19, 2009 12:51 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 11, 2012 10:26 AM
Points: 4, Visits: 22
Gift Peddie (8/19/2009)
If you are storing more than Portuguese in one column then you may need Nvarchar definition of your text columns data type and then using Portuguese collation on either table level or column level. You could also add it in your T-SQL code. Here is the System.Text.Encoding page and the SQL Server Windows collation page.

http://msdn.microsoft.com/en-us/library/system.text.encoding.aspx

http://msdn.microsoft.com/en-us/library/ms143508.aspx




The problem is not in SQL database. In database all text are saved correctly.
My question is about using the code from article “A Google-like Full Text Search”, and message error about the Portuguese characters appears when I try to convert a word with a Portuguese character.

Thanks & Regards,
Rui
Post #773832
Posted Wednesday, August 19, 2009 1:09 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, November 13, 2014 2:52 PM
Points: 3,428, Visits: 14,451
That article is calling a .NET dll that is parsing text on the binary level, you really don't need to parse most Western European text on the binary level. So you could just use a combination or saving .NET code as Portuguese per my first post or do Text encoding using Portuguese encoding before using the Google like search. The reason the article added Case statements to ANSI SQL predefined and Microsoft implemented Full Text predicates.


Kind regards,
Gift Peddie
Post #773841
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse