confused with all these terms

Can someone help me understand all these terms and so it remains in my thick
head ?
I keep hearing Unicode,Collation,Codepages,UTF-8,UTF-16,sort order
Can one tell me whats the standard collation we install ? whats UTF-8 and
16, do we use that ?http://msdn.microsoft.com/library/t...lserver2000.htm
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Hassan" <fatima_ja@.hotmail.com> wrote in message news:%23$rEdGAKFHA.1176@.TK2MSFTNGP12.phx.g
bl...
> Can someone help me understand all these terms and so it remains in my thi
ck
> head ?
> I keep hearing Unicode,Collation,Codepages,UTF-8,UTF-16,sort order
> Can one tell me whats the standard collation we install ? whats UTF-8 and
> 16, do we use that ?
>

confused with all these terms

Can someone help me understand all these terms and so it remains in my thick
head ?
I keep hearing Unicode,Collation,Codepages,UTF-8,UTF-16,sort order
Can one tell me whats the standard collation we install ? whats UTF-8 and
16, do we use that ?
http://msdn.microsoft.com/library/te...server2000.htm
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Hassan" <fatima_ja@.hotmail.com> wrote in message news:%23$rEdGAKFHA.1176@.TK2MSFTNGP12.phx.gbl...
> Can someone help me understand all these terms and so it remains in my thick
> head ?
> I keep hearing Unicode,Collation,Codepages,UTF-8,UTF-16,sort order
> Can one tell me whats the standard collation we install ? whats UTF-8 and
> 16, do we use that ?
>

confused with all these terms

Can someone help me understand all these terms and so it remains in my thick
head ?
I keep hearing Unicode,Collation,Codepages,UTF-8,UTF-16,sort order
Can one tell me whats the standard collation we install ? whats UTF-8 and
16, do we use that ?http://msdn.microsoft.com/library/techart/intlfeaturesinsqlserver2000.htm
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Hassan" <fatima_ja@.hotmail.com> wrote in message news:%23$rEdGAKFHA.1176@.TK2MSFTNGP12.phx.gbl...
> Can someone help me understand all these terms and so it remains in my thick
> head ?
> I keep hearing Unicode,Collation,Codepages,UTF-8,UTF-16,sort order
> Can one tell me whats the standard collation we install ? whats UTF-8 and
> 16, do we use that ?
>

Conflict in equal-to-operation

Hi there,

I am trying to update one table on server A/database A with new records from a server B/database B.

Both databases use the same collation. The key-fields of both table do use the same collation, but not the server.

Help: I was thinking, when both databases and the fields inside the tables do both use the same collation, then there will not upcome any conflict ?

Do I have to adapt the database collation, too ? This would'nt be nice as I am retreiving data from different servers with different server collations...
Anybody else got the same problem ?

Thx in advance

dajmI would imagine as long as the 2 fields have the same collation you would be alright because that would override both the db and server collations.|||I would imagine as long as the 2 fields have the same collation you would be alright because that would override both the db and server collations.

Hmm, I would have imagined the same, but it isn't. I re-created the tables, but get the same error. Collation is on <database default> on both fields and this is exactly the same...
:eek:

dajm