SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Support to search portuguese caracters


Support to search portuguese caracters

Author
Message
ruifrazao
ruifrazao
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
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
Gift Peddie
Gift Peddie
SSCertifiable
SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)

Group: General Forum Members
Points: 6250 Visits: 14456
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
ruifrazao
ruifrazao
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
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
Gift Peddie
Gift Peddie
SSCertifiable
SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)

Group: General Forum Members
Points: 6250 Visits: 14456
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
ruifrazao
ruifrazao
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
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
Gift Peddie
Gift Peddie
SSCertifiable
SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)

Group: General Forum Members
Points: 6250 Visits: 14456
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search