If I concatenate the varchar columns into a single column, I will (almost) duplicate the table size. That don’t look so good either and I don't like this idea very...

The purpose of including all columns in the FullText catalog, is the ability to search directly in all columns and, find all the records of the table that in at...

Here is the table:

 

CREATE TABLE [dbo].[ENTIDADE](
[COD_ENTD_ID] [decimal](18, 0) IDENTITY(0,1) NOT NULL,
[COD_ENTD] [varchar](20) NULL,
[COD_TIPO_ENTD_ID] [decimal](18, 0) NOT NULL,
[DES_SIGL] [varchar](100) NOT NULL,
[DES_DESG_SOCL] [varchar](100) NULL,
[DES_MORD] [varchar](100) NULL,
[DES_LOCL] [varchar](100) NULL,
[DES_CODG_POST] [varchar](50)...

Why does your code setup full text catalogues on EVERY VARCHAR column in the table?  Is that really necessary?  Depending on the schema of your table, that could be...

Someone know a unmanaged C++ version of this code?

Thanks

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...

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...