Hi,
I'm facing the error as the subject stated , "Cannot resolve collation
conflict for concatenation operation".
Base on running "print cast(
databasepropertyex( 'master', 'collation' ) as varchar(128) )", the
collation of sql2000 database is "Chinese_Taiwan_Stroke_CI_AS" .
I want to do searching on records in tables with partial matching on the
keywords.
the sql statement is :
select co.cms_content_id, co.title_en, ca.cms_category_id,
ca.category_name_en
from cms_content co, cms_sub_category sc, cms_category ca
where co.cms_sub_category_id = sc.cms_sub_category_id
AND sc.cms_category_id = ca.cms_category_id
AND co.status = 'active' collate Chinese_Taiwan_Stroke_CI_AS
AND(((title_ch like '%' + ? + '%' ) OR (title_en like '%' + ? + '%' ) ) )
order by co.active_from_date desc
as I will run this statement in java, the "?" will be filled into string and
both fields are nvarchar.
how should I do to solve this problm? thank you.
Try adding collation designators to the LIKE predicates:
select co.cms_content_id, co.title_en, ca.cms_category_id,
ca.category_name_en
from cms_content co, cms_sub_category sc, cms_category ca
where co.cms_sub_category_id = sc.cms_sub_category_id
AND sc.cms_category_id = ca.cms_category_id
AND co.status = 'active' collate Chinese_Taiwan_Stroke_CI_AS
AND(((title_ch like '%' + ? + '%' collate Chinese_Taiwan_Stroke_CI_AS)
OR (title_en like '%' + ? + '%' collate
inese_Taiwan_Stroke_CI_AS) ) )
order by co.active_from_date desc
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"little C" <little C@.discussions.microsoft.com> wrote in message
news:904CF870-C526-4BF5-AB89-3DAA75DC004D@.microsoft.com...
> Hi,
> I'm facing the error as the subject stated , "Cannot resolve collation
> conflict for concatenation operation".
> Base on running "print cast(
> databasepropertyex( 'master', 'collation' ) as varchar(128) )", the
> collation of sql2000 database is "Chinese_Taiwan_Stroke_CI_AS" .
> I want to do searching on records in tables with partial matching on the
> keywords.
> the sql statement is :
> select co.cms_content_id, co.title_en, ca.cms_category_id,
> ca.category_name_en
> from cms_content co, cms_sub_category sc, cms_category ca
> where co.cms_sub_category_id = sc.cms_sub_category_id
> AND sc.cms_category_id = ca.cms_category_id
> AND co.status = 'active' collate Chinese_Taiwan_Stroke_CI_AS
> AND(((title_ch like '%' + ? + '%' ) OR (title_en like '%' + ? +
' ) ) )
> order by co.active_from_date desc
> as I will run this statement in java, the "?" will be filled into string
and
> both fields are nvarchar.
> how should I do to solve this problm? thank you.
>
|||thanks Adam,
the problem is solved, I need to put "collate Chinese_Taiwan_Stroke_CI_AS"
right next to each "?". thanks a lot.
Chris C
"Adam Machanic" wrote:
> Try adding collation designators to the LIKE predicates:
>
> select co.cms_content_id, co.title_en, ca.cms_category_id,
> ca.category_name_en
> from cms_content co, cms_sub_category sc, cms_category ca
> where co.cms_sub_category_id = sc.cms_sub_category_id
> AND sc.cms_category_id = ca.cms_category_id
> AND co.status = 'active' collate Chinese_Taiwan_Stroke_CI_AS
> AND(((title_ch like '%' + ? + '%' collate Chinese_Taiwan_Stroke_CI_AS)
> OR (title_en like '%' + ? + '%' collate
> inese_Taiwan_Stroke_CI_AS) ) )
> order by co.active_from_date desc
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>
> "little C" <little C@.discussions.microsoft.com> wrote in message
> news:904CF870-C526-4BF5-AB89-3DAA75DC004D@.microsoft.com...
> ' ) ) )
> and
>
>
sqlsql
Showing posts with label base. Show all posts
Showing posts with label base. Show all posts
Thursday, March 22, 2012
collation conflict for concatenation operation
Hi,
I'm facing the error as the subject stated , "Cannot resolve collation
conflict for concatenation operation".
Base on running "print cast(
databasepropertyex( 'master', 'collation' ) as varchar(128) )", the
collation of sql2000 database is "Chinese_Taiwan_Stroke_CI_AS" .
I want to do searching on records in tables with partial matching on the
keywords.
the sql statement is :
select co.cms_content_id, co.title_en, ca.cms_category_id,
ca.category_name_en
from cms_content co, cms_sub_category sc, cms_category ca
where co.cms_sub_category_id = sc.cms_sub_category_id
AND sc.cms_category_id = ca.cms_category_id
AND co.status = 'active' collate Chinese_Taiwan_Stroke_CI_AS
AND(((title_ch like '%' + ? + '%' ) OR (title_en like '%' + ? + '%' ) )
)
order by co.active_from_date desc
as I will run this statement in java, the "?" will be filled into string and
both fields are nvarchar.
how should I do to solve this problm? thank you.Try adding collation designators to the LIKE predicates:
select co.cms_content_id, co.title_en, ca.cms_category_id,
ca.category_name_en
from cms_content co, cms_sub_category sc, cms_category ca
where co.cms_sub_category_id = sc.cms_sub_category_id
AND sc.cms_category_id = ca.cms_category_id
AND co.status = 'active' collate Chinese_Taiwan_Stroke_CI_AS
AND(((title_ch like '%' + ? + '%' collate Chinese_Taiwan_Stroke_CI_AS)
OR (title_en like '%' + ? + '%' collate
inese_Taiwan_Stroke_CI_AS) ) )
order by co.active_from_date desc
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"little C" <little C@.discussions.microsoft.com> wrote in message
news:904CF870-C526-4BF5-AB89-3DAA75DC004D@.microsoft.com...
> Hi,
> I'm facing the error as the subject stated , "Cannot resolve collation
> conflict for concatenation operation".
> Base on running "print cast(
> databasepropertyex( 'master', 'collation' ) as varchar(128) )", the
> collation of sql2000 database is "Chinese_Taiwan_Stroke_CI_AS" .
> I want to do searching on records in tables with partial matching on the
> keywords.
> the sql statement is :
> select co.cms_content_id, co.title_en, ca.cms_category_id,
> ca.category_name_en
> from cms_content co, cms_sub_category sc, cms_category ca
> where co.cms_sub_category_id = sc.cms_sub_category_id
> AND sc.cms_category_id = ca.cms_category_id
> AND co.status = 'active' collate Chinese_Taiwan_Stroke_CI_AS
> AND(((title_ch like '%' + ? + '%' ) OR (title_en like '%' + ? +
' ) ) )
> order by co.active_from_date desc
> as I will run this statement in java, the "?" will be filled into string
and
> both fields are nvarchar.
> how should I do to solve this problm? thank you.
>|||thanks Adam,
the problem is solved, I need to put "collate Chinese_Taiwan_Stroke_CI_AS"
right next to each "?". thanks a lot.
Chris C
"Adam Machanic" wrote:
> Try adding collation designators to the LIKE predicates:
>
> select co.cms_content_id, co.title_en, ca.cms_category_id,
> ca.category_name_en
> from cms_content co, cms_sub_category sc, cms_category ca
> where co.cms_sub_category_id = sc.cms_sub_category_id
> AND sc.cms_category_id = ca.cms_category_id
> AND co.status = 'active' collate Chinese_Taiwan_Stroke_CI_AS
> AND(((title_ch like '%' + ? + '%' collate Chinese_Taiwan_Stroke_CI_AS)
> OR (title_en like '%' + ? + '%' collate
> inese_Taiwan_Stroke_CI_AS) ) )
> order by co.active_from_date desc
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>
> "little C" <little C@.discussions.microsoft.com> wrote in message
> news:904CF870-C526-4BF5-AB89-3DAA75DC004D@.microsoft.com...
> ' ) ) )
> and
>
>
I'm facing the error as the subject stated , "Cannot resolve collation
conflict for concatenation operation".
Base on running "print cast(
databasepropertyex( 'master', 'collation' ) as varchar(128) )", the
collation of sql2000 database is "Chinese_Taiwan_Stroke_CI_AS" .
I want to do searching on records in tables with partial matching on the
keywords.
the sql statement is :
select co.cms_content_id, co.title_en, ca.cms_category_id,
ca.category_name_en
from cms_content co, cms_sub_category sc, cms_category ca
where co.cms_sub_category_id = sc.cms_sub_category_id
AND sc.cms_category_id = ca.cms_category_id
AND co.status = 'active' collate Chinese_Taiwan_Stroke_CI_AS
AND(((title_ch like '%' + ? + '%' ) OR (title_en like '%' + ? + '%' ) )
)
order by co.active_from_date desc
as I will run this statement in java, the "?" will be filled into string and
both fields are nvarchar.
how should I do to solve this problm? thank you.Try adding collation designators to the LIKE predicates:
select co.cms_content_id, co.title_en, ca.cms_category_id,
ca.category_name_en
from cms_content co, cms_sub_category sc, cms_category ca
where co.cms_sub_category_id = sc.cms_sub_category_id
AND sc.cms_category_id = ca.cms_category_id
AND co.status = 'active' collate Chinese_Taiwan_Stroke_CI_AS
AND(((title_ch like '%' + ? + '%' collate Chinese_Taiwan_Stroke_CI_AS)
OR (title_en like '%' + ? + '%' collate
inese_Taiwan_Stroke_CI_AS) ) )
order by co.active_from_date desc
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"little C" <little C@.discussions.microsoft.com> wrote in message
news:904CF870-C526-4BF5-AB89-3DAA75DC004D@.microsoft.com...
> Hi,
> I'm facing the error as the subject stated , "Cannot resolve collation
> conflict for concatenation operation".
> Base on running "print cast(
> databasepropertyex( 'master', 'collation' ) as varchar(128) )", the
> collation of sql2000 database is "Chinese_Taiwan_Stroke_CI_AS" .
> I want to do searching on records in tables with partial matching on the
> keywords.
> the sql statement is :
> select co.cms_content_id, co.title_en, ca.cms_category_id,
> ca.category_name_en
> from cms_content co, cms_sub_category sc, cms_category ca
> where co.cms_sub_category_id = sc.cms_sub_category_id
> AND sc.cms_category_id = ca.cms_category_id
> AND co.status = 'active' collate Chinese_Taiwan_Stroke_CI_AS
> AND(((title_ch like '%' + ? + '%' ) OR (title_en like '%' + ? +
' ) ) )
> order by co.active_from_date desc
> as I will run this statement in java, the "?" will be filled into string
and
> both fields are nvarchar.
> how should I do to solve this problm? thank you.
>|||thanks Adam,
the problem is solved, I need to put "collate Chinese_Taiwan_Stroke_CI_AS"
right next to each "?". thanks a lot.
Chris C
"Adam Machanic" wrote:
> Try adding collation designators to the LIKE predicates:
>
> select co.cms_content_id, co.title_en, ca.cms_category_id,
> ca.category_name_en
> from cms_content co, cms_sub_category sc, cms_category ca
> where co.cms_sub_category_id = sc.cms_sub_category_id
> AND sc.cms_category_id = ca.cms_category_id
> AND co.status = 'active' collate Chinese_Taiwan_Stroke_CI_AS
> AND(((title_ch like '%' + ? + '%' collate Chinese_Taiwan_Stroke_CI_AS)
> OR (title_en like '%' + ? + '%' collate
> inese_Taiwan_Stroke_CI_AS) ) )
> order by co.active_from_date desc
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>
> "little C" <little C@.discussions.microsoft.com> wrote in message
> news:904CF870-C526-4BF5-AB89-3DAA75DC004D@.microsoft.com...
> ' ) ) )
> and
>
>
collation conflict for concatenation operation
Hi,
I'm facing the error as the subject stated , "Cannot resolve collation
conflict for concatenation operation".
Base on running "print cast(
databasepropertyex( 'master', 'collation' ) as varchar(128) )", the
collation of sql2000 database is "Chinese_Taiwan_Stroke_CI_AS" .
I want to do searching on records in tables with partial matching on the
keywords.
the sql statement is :
select co.cms_content_id, co.title_en, ca.cms_category_id,
ca.category_name_en
from cms_content co, cms_sub_category sc, cms_category ca
where co.cms_sub_category_id = sc.cms_sub_category_id
AND sc.cms_category_id = ca.cms_category_id
AND co.status = 'active' collate Chinese_Taiwan_Stroke_CI_AS
AND(((title_ch like '%' + ? + '%' ) OR (title_en like '%' + ? + '%' ) ) )
order by co.active_from_date desc
as I will run this statement in java, the "?" will be filled into string and
both fields are nvarchar.
how should I do to solve this problm? thank you.Have you tried converting the data to unicode before
concatination ?
Peter
"I favor the Civil Rights Act of 1964 and it must be
enforced at gunpoint if necessary."
Ronald Reagan
>--Original Message--
>Hi,
>I'm facing the error as the subject stated , "Cannot
resolve collation
>conflict for concatenation operation".
>Base on running "print cast(
>databasepropertyex( 'master', 'collation' ) as varchar
(128) )", the
>collation of sql2000 database
is "Chinese_Taiwan_Stroke_CI_AS" .
>I want to do searching on records in tables with partial
matching on the
>keywords.
>the sql statement is :
>select co.cms_content_id, co.title_en,
ca.cms_category_id,
>ca.category_name_en
>from cms_content co, cms_sub_category sc, cms_category ca
>where co.cms_sub_category_id = sc.cms_sub_category_id
>AND sc.cms_category_id = ca.cms_category_id
>AND co.status = 'active' collate
Chinese_Taiwan_Stroke_CI_AS
>AND(((title_ch like '%' + ? + '%' ) OR (title_en
like '%' + ? + '%' ) ) )
>order by co.active_from_date desc
>as I will run this statement in java, the "?" will be
filled into string and
>both fields are nvarchar.
>how should I do to solve this problm? thank you.
>.
>|||Try adding collation designators to the LIKE predicates:
select co.cms_content_id, co.title_en, ca.cms_category_id,
ca.category_name_en
from cms_content co, cms_sub_category sc, cms_category ca
where co.cms_sub_category_id = sc.cms_sub_category_id
AND sc.cms_category_id = ca.cms_category_id
AND co.status = 'active' collate Chinese_Taiwan_Stroke_CI_AS
AND(((title_ch like '%' + ? + '%' collate Chinese_Taiwan_Stroke_CI_AS)
OR (title_en like '%' + ? + '%' collate
inese_Taiwan_Stroke_CI_AS) ) )
order by co.active_from_date desc
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"little C" <little C@.discussions.microsoft.com> wrote in message
news:904CF870-C526-4BF5-AB89-3DAA75DC004D@.microsoft.com...
> Hi,
> I'm facing the error as the subject stated , "Cannot resolve collation
> conflict for concatenation operation".
> Base on running "print cast(
> databasepropertyex( 'master', 'collation' ) as varchar(128) )", the
> collation of sql2000 database is "Chinese_Taiwan_Stroke_CI_AS" .
> I want to do searching on records in tables with partial matching on the
> keywords.
> the sql statement is :
> select co.cms_content_id, co.title_en, ca.cms_category_id,
> ca.category_name_en
> from cms_content co, cms_sub_category sc, cms_category ca
> where co.cms_sub_category_id = sc.cms_sub_category_id
> AND sc.cms_category_id = ca.cms_category_id
> AND co.status = 'active' collate Chinese_Taiwan_Stroke_CI_AS
> AND(((title_ch like '%' + ? + '%' ) OR (title_en like '%' + ? +
' ) ) )
> order by co.active_from_date desc
> as I will run this statement in java, the "?" will be filled into string
and
> both fields are nvarchar.
> how should I do to solve this problm? thank you.
>|||thanks Adam,
the problem is solved, I need to put "collate Chinese_Taiwan_Stroke_CI_AS"
right next to each "?". thanks a lot.
Chris C
"Adam Machanic" wrote:
> Try adding collation designators to the LIKE predicates:
>
> select co.cms_content_id, co.title_en, ca.cms_category_id,
> ca.category_name_en
> from cms_content co, cms_sub_category sc, cms_category ca
> where co.cms_sub_category_id = sc.cms_sub_category_id
> AND sc.cms_category_id = ca.cms_category_id
> AND co.status = 'active' collate Chinese_Taiwan_Stroke_CI_AS
> AND(((title_ch like '%' + ? + '%' collate Chinese_Taiwan_Stroke_CI_AS)
> OR (title_en like '%' + ? + '%' collate
> inese_Taiwan_Stroke_CI_AS) ) )
> order by co.active_from_date desc
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>
> "little C" <little C@.discussions.microsoft.com> wrote in message
> news:904CF870-C526-4BF5-AB89-3DAA75DC004D@.microsoft.com...
> > Hi,
> >
> > I'm facing the error as the subject stated , "Cannot resolve collation
> > conflict for concatenation operation".
> >
> > Base on running "print cast(
> > databasepropertyex( 'master', 'collation' ) as varchar(128) )", the
> > collation of sql2000 database is "Chinese_Taiwan_Stroke_CI_AS" .
> >
> > I want to do searching on records in tables with partial matching on the
> > keywords.
> >
> > the sql statement is :
> >
> > select co.cms_content_id, co.title_en, ca.cms_category_id,
> > ca.category_name_en
> > from cms_content co, cms_sub_category sc, cms_category ca
> > where co.cms_sub_category_id = sc.cms_sub_category_id
> > AND sc.cms_category_id = ca.cms_category_id
> > AND co.status = 'active' collate Chinese_Taiwan_Stroke_CI_AS
> > AND(((title_ch like '%' + ? + '%' ) OR (title_en like '%' + ? +
> ' ) ) )
> > order by co.active_from_date desc
> >
> > as I will run this statement in java, the "?" will be filled into string
> and
> > both fields are nvarchar.
> >
> > how should I do to solve this problm? thank you.
> >
>
>
I'm facing the error as the subject stated , "Cannot resolve collation
conflict for concatenation operation".
Base on running "print cast(
databasepropertyex( 'master', 'collation' ) as varchar(128) )", the
collation of sql2000 database is "Chinese_Taiwan_Stroke_CI_AS" .
I want to do searching on records in tables with partial matching on the
keywords.
the sql statement is :
select co.cms_content_id, co.title_en, ca.cms_category_id,
ca.category_name_en
from cms_content co, cms_sub_category sc, cms_category ca
where co.cms_sub_category_id = sc.cms_sub_category_id
AND sc.cms_category_id = ca.cms_category_id
AND co.status = 'active' collate Chinese_Taiwan_Stroke_CI_AS
AND(((title_ch like '%' + ? + '%' ) OR (title_en like '%' + ? + '%' ) ) )
order by co.active_from_date desc
as I will run this statement in java, the "?" will be filled into string and
both fields are nvarchar.
how should I do to solve this problm? thank you.Have you tried converting the data to unicode before
concatination ?
Peter
"I favor the Civil Rights Act of 1964 and it must be
enforced at gunpoint if necessary."
Ronald Reagan
>--Original Message--
>Hi,
>I'm facing the error as the subject stated , "Cannot
resolve collation
>conflict for concatenation operation".
>Base on running "print cast(
>databasepropertyex( 'master', 'collation' ) as varchar
(128) )", the
>collation of sql2000 database
is "Chinese_Taiwan_Stroke_CI_AS" .
>I want to do searching on records in tables with partial
matching on the
>keywords.
>the sql statement is :
>select co.cms_content_id, co.title_en,
ca.cms_category_id,
>ca.category_name_en
>from cms_content co, cms_sub_category sc, cms_category ca
>where co.cms_sub_category_id = sc.cms_sub_category_id
>AND sc.cms_category_id = ca.cms_category_id
>AND co.status = 'active' collate
Chinese_Taiwan_Stroke_CI_AS
>AND(((title_ch like '%' + ? + '%' ) OR (title_en
like '%' + ? + '%' ) ) )
>order by co.active_from_date desc
>as I will run this statement in java, the "?" will be
filled into string and
>both fields are nvarchar.
>how should I do to solve this problm? thank you.
>.
>|||Try adding collation designators to the LIKE predicates:
select co.cms_content_id, co.title_en, ca.cms_category_id,
ca.category_name_en
from cms_content co, cms_sub_category sc, cms_category ca
where co.cms_sub_category_id = sc.cms_sub_category_id
AND sc.cms_category_id = ca.cms_category_id
AND co.status = 'active' collate Chinese_Taiwan_Stroke_CI_AS
AND(((title_ch like '%' + ? + '%' collate Chinese_Taiwan_Stroke_CI_AS)
OR (title_en like '%' + ? + '%' collate
inese_Taiwan_Stroke_CI_AS) ) )
order by co.active_from_date desc
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"little C" <little C@.discussions.microsoft.com> wrote in message
news:904CF870-C526-4BF5-AB89-3DAA75DC004D@.microsoft.com...
> Hi,
> I'm facing the error as the subject stated , "Cannot resolve collation
> conflict for concatenation operation".
> Base on running "print cast(
> databasepropertyex( 'master', 'collation' ) as varchar(128) )", the
> collation of sql2000 database is "Chinese_Taiwan_Stroke_CI_AS" .
> I want to do searching on records in tables with partial matching on the
> keywords.
> the sql statement is :
> select co.cms_content_id, co.title_en, ca.cms_category_id,
> ca.category_name_en
> from cms_content co, cms_sub_category sc, cms_category ca
> where co.cms_sub_category_id = sc.cms_sub_category_id
> AND sc.cms_category_id = ca.cms_category_id
> AND co.status = 'active' collate Chinese_Taiwan_Stroke_CI_AS
> AND(((title_ch like '%' + ? + '%' ) OR (title_en like '%' + ? +
' ) ) )
> order by co.active_from_date desc
> as I will run this statement in java, the "?" will be filled into string
and
> both fields are nvarchar.
> how should I do to solve this problm? thank you.
>|||thanks Adam,
the problem is solved, I need to put "collate Chinese_Taiwan_Stroke_CI_AS"
right next to each "?". thanks a lot.
Chris C
"Adam Machanic" wrote:
> Try adding collation designators to the LIKE predicates:
>
> select co.cms_content_id, co.title_en, ca.cms_category_id,
> ca.category_name_en
> from cms_content co, cms_sub_category sc, cms_category ca
> where co.cms_sub_category_id = sc.cms_sub_category_id
> AND sc.cms_category_id = ca.cms_category_id
> AND co.status = 'active' collate Chinese_Taiwan_Stroke_CI_AS
> AND(((title_ch like '%' + ? + '%' collate Chinese_Taiwan_Stroke_CI_AS)
> OR (title_en like '%' + ? + '%' collate
> inese_Taiwan_Stroke_CI_AS) ) )
> order by co.active_from_date desc
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>
> "little C" <little C@.discussions.microsoft.com> wrote in message
> news:904CF870-C526-4BF5-AB89-3DAA75DC004D@.microsoft.com...
> > Hi,
> >
> > I'm facing the error as the subject stated , "Cannot resolve collation
> > conflict for concatenation operation".
> >
> > Base on running "print cast(
> > databasepropertyex( 'master', 'collation' ) as varchar(128) )", the
> > collation of sql2000 database is "Chinese_Taiwan_Stroke_CI_AS" .
> >
> > I want to do searching on records in tables with partial matching on the
> > keywords.
> >
> > the sql statement is :
> >
> > select co.cms_content_id, co.title_en, ca.cms_category_id,
> > ca.category_name_en
> > from cms_content co, cms_sub_category sc, cms_category ca
> > where co.cms_sub_category_id = sc.cms_sub_category_id
> > AND sc.cms_category_id = ca.cms_category_id
> > AND co.status = 'active' collate Chinese_Taiwan_Stroke_CI_AS
> > AND(((title_ch like '%' + ? + '%' ) OR (title_en like '%' + ? +
> ' ) ) )
> > order by co.active_from_date desc
> >
> > as I will run this statement in java, the "?" will be filled into string
> and
> > both fields are nvarchar.
> >
> > how should I do to solve this problm? thank you.
> >
>
>
Monday, March 19, 2012
COLLATE Question
Greetings to all. It would thank for much to them if they
could help me with a problem, that is the following one: I
have a data base in a server x with a table with a field
that has the COLLATE in Hungarian_CS_AI, and at the time
of concatenating this field with a field that has the
COLLATE of the SQL_Latin1_General_CP1_CI_AI type and when
executing this marks an error to me and it solved it
adding at the end of the sentence that the COLLATE of a
single type, but that is not what I look for but what I
would like that somebody explains to me in case a type of
COLLATE exists that can support to all the types like a
UNICODE or something similar. It is for this reason that I
need to know if it is possible to do that single collate
accepts all type of characters. Thanks.
Have you tried to bring the data with the different collation types into another table that has only one collation. Do you need the Hungarian collation still? If so I am assuming that the Hungarian collation (due to the need for more special characters) w
ould allow for all Latin1 permissible characters and therefore try to port your Latin collation data to Hungarian collation.
|||So why not use Unicode?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Miramontes" <anonymous@.discussions.microsoft.com> wrote in message
news:1afb001c44f3f$e3dad580$a401280a@.phx.gbl...
> Greetings to all. It would thank for much to them if they
> could help me with a problem, that is the following one: I
> have a data base in a server x with a table with a field
> that has the COLLATE in Hungarian_CS_AI, and at the time
> of concatenating this field with a field that has the
> COLLATE of the SQL_Latin1_General_CP1_CI_AI type and when
> executing this marks an error to me and it solved it
> adding at the end of the sentence that the COLLATE of a
> single type, but that is not what I look for but what I
> would like that somebody explains to me in case a type of
> COLLATE exists that can support to all the types like a
> UNICODE or something similar. It is for this reason that I
> need to know if it is possible to do that single collate
> accepts all type of characters. Thanks.
|||Do you now the name for this type of collate for
unicode ?, because i need that unicode.
Thanks in advanced.
>--Original Message--
>So why not use Unicode?
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Miramontes" <anonymous@.discussions.microsoft.com> wrote
in message[vbcol=seagreen]
>news:1afb001c44f3f$e3dad580$a401280a@.phx.gbl...
they[vbcol=seagreen]
one: I[vbcol=seagreen]
when[vbcol=seagreen]
of[vbcol=seagreen]
that I
>
>.
>
|||Unicode is the datatype (actually nvarchar, nchar and ntext). You then pick a collation to go with it. Seems
like Hungarian_CS_AI should be the one to use, as the other is "general", hence shouldn't care how the
"extended" characters are sorted etc.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Miramontes" <anonymous@.discussions.microsoft.com> wrote in message
news:1b69901c44fba$dffe8fd0$a001280a@.phx.gbl...[vbcol=seagreen]
> Do you now the name for this type of collate for
> unicode ?, because i need that unicode.
> Thanks in advanced.
> in message
> they
> one: I
> when
> of
> that I
could help me with a problem, that is the following one: I
have a data base in a server x with a table with a field
that has the COLLATE in Hungarian_CS_AI, and at the time
of concatenating this field with a field that has the
COLLATE of the SQL_Latin1_General_CP1_CI_AI type and when
executing this marks an error to me and it solved it
adding at the end of the sentence that the COLLATE of a
single type, but that is not what I look for but what I
would like that somebody explains to me in case a type of
COLLATE exists that can support to all the types like a
UNICODE or something similar. It is for this reason that I
need to know if it is possible to do that single collate
accepts all type of characters. Thanks.
Have you tried to bring the data with the different collation types into another table that has only one collation. Do you need the Hungarian collation still? If so I am assuming that the Hungarian collation (due to the need for more special characters) w
ould allow for all Latin1 permissible characters and therefore try to port your Latin collation data to Hungarian collation.
|||So why not use Unicode?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Miramontes" <anonymous@.discussions.microsoft.com> wrote in message
news:1afb001c44f3f$e3dad580$a401280a@.phx.gbl...
> Greetings to all. It would thank for much to them if they
> could help me with a problem, that is the following one: I
> have a data base in a server x with a table with a field
> that has the COLLATE in Hungarian_CS_AI, and at the time
> of concatenating this field with a field that has the
> COLLATE of the SQL_Latin1_General_CP1_CI_AI type and when
> executing this marks an error to me and it solved it
> adding at the end of the sentence that the COLLATE of a
> single type, but that is not what I look for but what I
> would like that somebody explains to me in case a type of
> COLLATE exists that can support to all the types like a
> UNICODE or something similar. It is for this reason that I
> need to know if it is possible to do that single collate
> accepts all type of characters. Thanks.
|||Do you now the name for this type of collate for
unicode ?, because i need that unicode.
Thanks in advanced.
>--Original Message--
>So why not use Unicode?
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Miramontes" <anonymous@.discussions.microsoft.com> wrote
in message[vbcol=seagreen]
>news:1afb001c44f3f$e3dad580$a401280a@.phx.gbl...
they[vbcol=seagreen]
one: I[vbcol=seagreen]
when[vbcol=seagreen]
of[vbcol=seagreen]
that I
>
>.
>
|||Unicode is the datatype (actually nvarchar, nchar and ntext). You then pick a collation to go with it. Seems
like Hungarian_CS_AI should be the one to use, as the other is "general", hence shouldn't care how the
"extended" characters are sorted etc.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Miramontes" <anonymous@.discussions.microsoft.com> wrote in message
news:1b69901c44fba$dffe8fd0$a001280a@.phx.gbl...[vbcol=seagreen]
> Do you now the name for this type of collate for
> unicode ?, because i need that unicode.
> Thanks in advanced.
> in message
> they
> one: I
> when
> of
> that I
COLLATE Question
Greetings to all. It would thank for much to them if they
could help me with a problem, that is the following one: I
have a data base in a server x with a table with a field
that has the COLLATE in Hungarian_CS_AI, and at the time
of concatenating this field with a field that has the
COLLATE of the SQL_Latin1_General_CP1_CI_AI type and when
executing this marks an error to me and it solved it
adding at the end of the sentence that the COLLATE of a
single type, but that is not what I look for but what I
would like that somebody explains to me in case a type of
COLLATE exists that can support to all the types like a
UNICODE or something similar. It is for this reason that I
need to know if it is possible to do that single collate
accepts all type of characters. Thanks.Have you tried to bring the data with the different collation types into ano
ther table that has only one collation. Do you need the Hungarian collation
still? If so I am assuming that the Hungarian collation (due to the need for
more special characters) w
ould allow for all Latin1 permissible characters and therefore try to port y
our Latin collation data to Hungarian collation.|||So why not use Unicode?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Miramontes" <anonymous@.discussions.microsoft.com> wrote in message
news:1afb001c44f3f$e3dad580$a401280a@.phx
.gbl...
> Greetings to all. It would thank for much to them if they
> could help me with a problem, that is the following one: I
> have a data base in a server x with a table with a field
> that has the COLLATE in Hungarian_CS_AI, and at the time
> of concatenating this field with a field that has the
> COLLATE of the SQL_Latin1_General_CP1_CI_AI type and when
> executing this marks an error to me and it solved it
> adding at the end of the sentence that the COLLATE of a
> single type, but that is not what I look for but what I
> would like that somebody explains to me in case a type of
> COLLATE exists that can support to all the types like a
> UNICODE or something similar. It is for this reason that I
> need to know if it is possible to do that single collate
> accepts all type of characters. Thanks.|||Do you now the name for this type of collate for
unicode ?, because i need that unicode.
Thanks in advanced.
>--Original Message--
>So why not use Unicode?
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Miramontes" <anonymous@.discussions.microsoft.com> wrote
in message
> news:1afb001c44f3f$e3dad580$a401280a@.phx
.gbl...
they[vbcol=seagreen]
one: I[vbcol=seagreen]
when[vbcol=seagreen]
of[vbcol=seagreen]
that I[vbcol=seagreen]
>
>.
>|||Unicode is the datatype (actually nvarchar, nchar and ntext). You then pick
a collation to go with it. Seems
like Hungarian_CS_AI should be the one to use, as the other is "general", he
nce shouldn't care how the
"extended" characters are sorted etc.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Miramontes" <anonymous@.discussions.microsoft.com> wrote in message
news:1b69901c44fba$dffe8fd0$a001280a@.phx
.gbl...[vbcol=seagreen]
> Do you now the name for this type of collate for
> unicode ?, because i need that unicode.
> Thanks in advanced.
>
> in message
> they
> one: I
> when
> of
> that I
could help me with a problem, that is the following one: I
have a data base in a server x with a table with a field
that has the COLLATE in Hungarian_CS_AI, and at the time
of concatenating this field with a field that has the
COLLATE of the SQL_Latin1_General_CP1_CI_AI type and when
executing this marks an error to me and it solved it
adding at the end of the sentence that the COLLATE of a
single type, but that is not what I look for but what I
would like that somebody explains to me in case a type of
COLLATE exists that can support to all the types like a
UNICODE or something similar. It is for this reason that I
need to know if it is possible to do that single collate
accepts all type of characters. Thanks.Have you tried to bring the data with the different collation types into ano
ther table that has only one collation. Do you need the Hungarian collation
still? If so I am assuming that the Hungarian collation (due to the need for
more special characters) w
ould allow for all Latin1 permissible characters and therefore try to port y
our Latin collation data to Hungarian collation.|||So why not use Unicode?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Miramontes" <anonymous@.discussions.microsoft.com> wrote in message
news:1afb001c44f3f$e3dad580$a401280a@.phx
.gbl...
> Greetings to all. It would thank for much to them if they
> could help me with a problem, that is the following one: I
> have a data base in a server x with a table with a field
> that has the COLLATE in Hungarian_CS_AI, and at the time
> of concatenating this field with a field that has the
> COLLATE of the SQL_Latin1_General_CP1_CI_AI type and when
> executing this marks an error to me and it solved it
> adding at the end of the sentence that the COLLATE of a
> single type, but that is not what I look for but what I
> would like that somebody explains to me in case a type of
> COLLATE exists that can support to all the types like a
> UNICODE or something similar. It is for this reason that I
> need to know if it is possible to do that single collate
> accepts all type of characters. Thanks.|||Do you now the name for this type of collate for
unicode ?, because i need that unicode.
Thanks in advanced.
>--Original Message--
>So why not use Unicode?
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Miramontes" <anonymous@.discussions.microsoft.com> wrote
in message
> news:1afb001c44f3f$e3dad580$a401280a@.phx
.gbl...
they[vbcol=seagreen]
one: I[vbcol=seagreen]
when[vbcol=seagreen]
of[vbcol=seagreen]
that I[vbcol=seagreen]
>
>.
>|||Unicode is the datatype (actually nvarchar, nchar and ntext). You then pick
a collation to go with it. Seems
like Hungarian_CS_AI should be the one to use, as the other is "general", he
nce shouldn't care how the
"extended" characters are sorted etc.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Miramontes" <anonymous@.discussions.microsoft.com> wrote in message
news:1b69901c44fba$dffe8fd0$a001280a@.phx
.gbl...[vbcol=seagreen]
> Do you now the name for this type of collate for
> unicode ?, because i need that unicode.
> Thanks in advanced.
>
> in message
> they
> one: I
> when
> of
> that I
COLLATE Question
Greetings to all. It would thank for much to them if they
could help me with a problem, that is the following one: I
have a data base in a server x with a table with a field
that has the COLLATE in Hungarian_CS_AI, and at the time
of concatenating this field with a field that has the
COLLATE of the SQL_Latin1_General_CP1_CI_AI type and when
executing this marks an error to me and it solved it
adding at the end of the sentence that the COLLATE of a
single type, but that is not what I look for but what I
would like that somebody explains to me in case a type of
COLLATE exists that can support to all the types like a
UNICODE or something similar. It is for this reason that I
need to know if it is possible to do that single collate
accepts all type of characters. Thanks.Have you tried to bring the data with the different collation types into another table that has only one collation. Do you need the Hungarian collation still? If so I am assuming that the Hungarian collation (due to the need for more special characters) would allow for all Latin1 permissible characters and therefore try to port your Latin collation data to Hungarian collation.|||So why not use Unicode?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Miramontes" <anonymous@.discussions.microsoft.com> wrote in message
news:1afb001c44f3f$e3dad580$a401280a@.phx.gbl...
> Greetings to all. It would thank for much to them if they
> could help me with a problem, that is the following one: I
> have a data base in a server x with a table with a field
> that has the COLLATE in Hungarian_CS_AI, and at the time
> of concatenating this field with a field that has the
> COLLATE of the SQL_Latin1_General_CP1_CI_AI type and when
> executing this marks an error to me and it solved it
> adding at the end of the sentence that the COLLATE of a
> single type, but that is not what I look for but what I
> would like that somebody explains to me in case a type of
> COLLATE exists that can support to all the types like a
> UNICODE or something similar. It is for this reason that I
> need to know if it is possible to do that single collate
> accepts all type of characters. Thanks.|||Do you now the name for this type of collate for
unicode ?, because i need that unicode.
Thanks in advanced.
>--Original Message--
>So why not use Unicode?
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Miramontes" <anonymous@.discussions.microsoft.com> wrote
in message
>news:1afb001c44f3f$e3dad580$a401280a@.phx.gbl...
>> Greetings to all. It would thank for much to them if
they
>> could help me with a problem, that is the following
one: I
>> have a data base in a server x with a table with a field
>> that has the COLLATE in Hungarian_CS_AI, and at the time
>> of concatenating this field with a field that has the
>> COLLATE of the SQL_Latin1_General_CP1_CI_AI type and
when
>> executing this marks an error to me and it solved it
>> adding at the end of the sentence that the COLLATE of a
>> single type, but that is not what I look for but what I
>> would like that somebody explains to me in case a type
of
>> COLLATE exists that can support to all the types like a
>> UNICODE or something similar. It is for this reason
that I
>> need to know if it is possible to do that single collate
>> accepts all type of characters. Thanks.
>
>.
>|||Unicode is the datatype (actually nvarchar, nchar and ntext). You then pick a collation to go with it. Seems
like Hungarian_CS_AI should be the one to use, as the other is "general", hence shouldn't care how the
"extended" characters are sorted etc.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Miramontes" <anonymous@.discussions.microsoft.com> wrote in message
news:1b69901c44fba$dffe8fd0$a001280a@.phx.gbl...
> Do you now the name for this type of collate for
> unicode ?, because i need that unicode.
> Thanks in advanced.
> >--Original Message--
> >So why not use Unicode?
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >http://www.karaszi.com/sqlserver/default.asp
> >http://www.solidqualitylearning.com/
> >
> >
> >"Miramontes" <anonymous@.discussions.microsoft.com> wrote
> in message
> >news:1afb001c44f3f$e3dad580$a401280a@.phx.gbl...
> >> Greetings to all. It would thank for much to them if
> they
> >> could help me with a problem, that is the following
> one: I
> >> have a data base in a server x with a table with a field
> >> that has the COLLATE in Hungarian_CS_AI, and at the time
> >> of concatenating this field with a field that has the
> >> COLLATE of the SQL_Latin1_General_CP1_CI_AI type and
> when
> >> executing this marks an error to me and it solved it
> >> adding at the end of the sentence that the COLLATE of a
> >> single type, but that is not what I look for but what I
> >> would like that somebody explains to me in case a type
> of
> >> COLLATE exists that can support to all the types like a
> >> UNICODE or something similar. It is for this reason
> that I
> >> need to know if it is possible to do that single collate
> >> accepts all type of characters. Thanks.
> >
> >
> >.
> >
could help me with a problem, that is the following one: I
have a data base in a server x with a table with a field
that has the COLLATE in Hungarian_CS_AI, and at the time
of concatenating this field with a field that has the
COLLATE of the SQL_Latin1_General_CP1_CI_AI type and when
executing this marks an error to me and it solved it
adding at the end of the sentence that the COLLATE of a
single type, but that is not what I look for but what I
would like that somebody explains to me in case a type of
COLLATE exists that can support to all the types like a
UNICODE or something similar. It is for this reason that I
need to know if it is possible to do that single collate
accepts all type of characters. Thanks.Have you tried to bring the data with the different collation types into another table that has only one collation. Do you need the Hungarian collation still? If so I am assuming that the Hungarian collation (due to the need for more special characters) would allow for all Latin1 permissible characters and therefore try to port your Latin collation data to Hungarian collation.|||So why not use Unicode?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Miramontes" <anonymous@.discussions.microsoft.com> wrote in message
news:1afb001c44f3f$e3dad580$a401280a@.phx.gbl...
> Greetings to all. It would thank for much to them if they
> could help me with a problem, that is the following one: I
> have a data base in a server x with a table with a field
> that has the COLLATE in Hungarian_CS_AI, and at the time
> of concatenating this field with a field that has the
> COLLATE of the SQL_Latin1_General_CP1_CI_AI type and when
> executing this marks an error to me and it solved it
> adding at the end of the sentence that the COLLATE of a
> single type, but that is not what I look for but what I
> would like that somebody explains to me in case a type of
> COLLATE exists that can support to all the types like a
> UNICODE or something similar. It is for this reason that I
> need to know if it is possible to do that single collate
> accepts all type of characters. Thanks.|||Do you now the name for this type of collate for
unicode ?, because i need that unicode.
Thanks in advanced.
>--Original Message--
>So why not use Unicode?
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Miramontes" <anonymous@.discussions.microsoft.com> wrote
in message
>news:1afb001c44f3f$e3dad580$a401280a@.phx.gbl...
>> Greetings to all. It would thank for much to them if
they
>> could help me with a problem, that is the following
one: I
>> have a data base in a server x with a table with a field
>> that has the COLLATE in Hungarian_CS_AI, and at the time
>> of concatenating this field with a field that has the
>> COLLATE of the SQL_Latin1_General_CP1_CI_AI type and
when
>> executing this marks an error to me and it solved it
>> adding at the end of the sentence that the COLLATE of a
>> single type, but that is not what I look for but what I
>> would like that somebody explains to me in case a type
of
>> COLLATE exists that can support to all the types like a
>> UNICODE or something similar. It is for this reason
that I
>> need to know if it is possible to do that single collate
>> accepts all type of characters. Thanks.
>
>.
>|||Unicode is the datatype (actually nvarchar, nchar and ntext). You then pick a collation to go with it. Seems
like Hungarian_CS_AI should be the one to use, as the other is "general", hence shouldn't care how the
"extended" characters are sorted etc.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Miramontes" <anonymous@.discussions.microsoft.com> wrote in message
news:1b69901c44fba$dffe8fd0$a001280a@.phx.gbl...
> Do you now the name for this type of collate for
> unicode ?, because i need that unicode.
> Thanks in advanced.
> >--Original Message--
> >So why not use Unicode?
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >http://www.karaszi.com/sqlserver/default.asp
> >http://www.solidqualitylearning.com/
> >
> >
> >"Miramontes" <anonymous@.discussions.microsoft.com> wrote
> in message
> >news:1afb001c44f3f$e3dad580$a401280a@.phx.gbl...
> >> Greetings to all. It would thank for much to them if
> they
> >> could help me with a problem, that is the following
> one: I
> >> have a data base in a server x with a table with a field
> >> that has the COLLATE in Hungarian_CS_AI, and at the time
> >> of concatenating this field with a field that has the
> >> COLLATE of the SQL_Latin1_General_CP1_CI_AI type and
> when
> >> executing this marks an error to me and it solved it
> >> adding at the end of the sentence that the COLLATE of a
> >> single type, but that is not what I look for but what I
> >> would like that somebody explains to me in case a type
> of
> >> COLLATE exists that can support to all the types like a
> >> UNICODE or something similar. It is for this reason
> that I
> >> need to know if it is possible to do that single collate
> >> accepts all type of characters. Thanks.
> >
> >
> >.
> >
Thursday, March 8, 2012
code page
Can we copy a 850 code page base to a standby one with 1252 code page ?Yes, but without using dump/restore
Subscribe to:
Posts (Atom)