Does SQL server supports Cable Redundancy ?

Does SQL server supports Cable Redundancy. A system having 2 NIC's for LAN
redundancy.
Thanks
AnilG
Hi
As long as both are connected to different segments, yes. That is a windows
limitation.
SQL server will listen on all NICs by default so it does not care. The Os
provides the functionality. The bigger challenge is to get your DNS to
change quick enough otherwise some users will hit the dead IP.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Anil Gopu" <AnilGopu@.discussions.microsoft.com> wrote in message
news:1682BC47-4E22-4F24-BEAA-2D8C6A771074@.microsoft.com...
> Does SQL server supports Cable Redundancy. A system having 2 NIC's for LAN
> redundancy.
> --
> Thanks
> AnilG
|||Can I know what is meant by different segements. I am basically a VC++
programmer.
Thanks
AnilG
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> As long as both are connected to different segments, yes. That is a windows
> limitation.
> SQL server will listen on all NICs by default so it does not care. The Os
> provides the functionality. The bigger challenge is to get your DNS to
> change quick enough otherwise some users will hit the dead IP.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Anil Gopu" <AnilGopu@.discussions.microsoft.com> wrote in message
> news:1682BC47-4E22-4F24-BEAA-2D8C6A771074@.microsoft.com...
>
>
|||Hi,
Segments are networks or part of. You might have one segment with a
192.168.1 ip address and the other with 192.168.2 ip address. If you have
two network card in a machine they can be connected to two network segments.
The issue you raised is a Windows issue and depends on how you setup the
cards
kind regards
Greg O
Need to document your databases. Use the first and still the best AGS SQL
Scribe
http://www.ag-software.com
"Anil Gopu" <AnilGopu@.discussions.microsoft.com> wrote in message
news:AE540719-6953-44B3-9DD5-75099EC2D9FB@.microsoft.com...[vbcol=seagreen]
> Can I know what is meant by different segements. I am basically a VC++
> programmer.
> --
> Thanks
> AnilG
>
> "Mike Epprecht (SQL MVP)" wrote:
|||Cable redundancy is working for Win 2003 server when applied a hotfix as
given in KB : http://support.microsoft.com/default...;en-us;817690.
But we facing the same problem in Win XP SP2. Any clues.
Thanks
AnilG
"GregO" wrote:

> Hi,
> Segments are networks or part of. You might have one segment with a
> 192.168.1 ip address and the other with 192.168.2 ip address. If you have
> two network card in a machine they can be connected to two network segments.
> The issue you raised is a Windows issue and depends on how you setup the
> cards
>
> --
> kind regards
> Greg O
> Need to document your databases. Use the first and still the best AGS SQL
> Scribe
> http://www.ag-software.com
> "Anil Gopu" <AnilGopu@.discussions.microsoft.com> wrote in message
> news:AE540719-6953-44B3-9DD5-75099EC2D9FB@.microsoft.com...
>
>

Does SQL server supports Cable Redundancy ?

Does SQL server supports Cable Redundancy. A system having 2 NIC's for LAN
redundancy.
Thanks
AnilGHi
As long as both are connected to different segments, yes. That is a windows
limitation.
SQL server will listen on all NICs by default so it does not care. The Os
provides the functionality. The bigger challenge is to get your DNS to
change quick enough otherwise some users will hit the dead IP.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Anil Gopu" <AnilGopu@.discussions.microsoft.com> wrote in message
news:1682BC47-4E22-4F24-BEAA-2D8C6A771074@.microsoft.com...
> Does SQL server supports Cable Redundancy. A system having 2 NIC's for LAN
> redundancy.
> --
> Thanks
> AnilG|||Can I know what is meant by different segements. I am basically a VC++
programmer.
Thanks
AnilG
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> As long as both are connected to different segments, yes. That is a window
s
> limitation.
> SQL server will listen on all NICs by default so it does not care. The Os
> provides the functionality. The bigger challenge is to get your DNS to
> change quick enough otherwise some users will hit the dead IP.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Anil Gopu" <AnilGopu@.discussions.microsoft.com> wrote in message
> news:1682BC47-4E22-4F24-BEAA-2D8C6A771074@.microsoft.com...
>
>|||Hi,
Segments are networks or part of. You might have one segment with a
192.168.1 ip address and the other with 192.168.2 ip address. If you have
two network card in a machine they can be connected to two network segments.
The issue you raised is a Windows issue and depends on how you setup the
cards
kind regards
Greg O
Need to document your databases. Use the first and still the best AGS SQL
Scribe
http://www.ag-software.com
"Anil Gopu" <AnilGopu@.discussions.microsoft.com> wrote in message
news:AE540719-6953-44B3-9DD5-75099EC2D9FB@.microsoft.com...[vbcol=seagreen]
> Can I know what is meant by different segements. I am basically a VC++
> programmer.
> --
> Thanks
> AnilG
>
> "Mike Epprecht (SQL MVP)" wrote:
>|||Cable redundancy is working for Win 2003 server when applied a hotfix as
given in KB : [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;817690.[/url
]
But we facing the same problem in Win XP SP2. Any clues.
--
Thanks
AnilG
"GregO" wrote:

> Hi,
> Segments are networks or part of. You might have one segment with a
> 192.168.1 ip address and the other with 192.168.2 ip address. If you have
> two network card in a machine they can be connected to two network segment
s.
> The issue you raised is a Windows issue and depends on how you setup the
> cards
>
> --
> kind regards
> Greg O
> Need to document your databases. Use the first and still the best AGS SQL
> Scribe
> http://www.ag-software.com
> "Anil Gopu" <AnilGopu@.discussions.microsoft.com> wrote in message
> news:AE540719-6953-44B3-9DD5-75099EC2D9FB@.microsoft.com...
>
>|||I am also having this same problem. How do you get the DNS to change quick
enough, so that the SQL db Admin's don't call me everytime they can not
connect? I have unchecked the "register this connections address in DNS" an
d
it still registers the address in DNS. The server that I am having problems
with is also a DNS server. Any suggestions?
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> As long as both are connected to different segments, yes. That is a window
s
> limitation.
> SQL server will listen on all NICs by default so it does not care. The Os
> provides the functionality. The bigger challenge is to get your DNS to
> change quick enough otherwise some users will hit the dead IP.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Anil Gopu" <AnilGopu@.discussions.microsoft.com> wrote in message
> news:1682BC47-4E22-4F24-BEAA-2D8C6A771074@.microsoft.com...
>
>sql

Does SQL server supports Cable Redundancy ?

Does SQL server supports Cable Redundancy. A system having 2 NIC's for LAN
redundancy.
--
Thanks
AnilGHi
As long as both are connected to different segments, yes. That is a windows
limitation.
SQL server will listen on all NICs by default so it does not care. The Os
provides the functionality. The bigger challenge is to get your DNS to
change quick enough otherwise some users will hit the dead IP.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Anil Gopu" <AnilGopu@.discussions.microsoft.com> wrote in message
news:1682BC47-4E22-4F24-BEAA-2D8C6A771074@.microsoft.com...
> Does SQL server supports Cable Redundancy. A system having 2 NIC's for LAN
> redundancy.
> --
> Thanks
> AnilG|||Can I know what is meant by different segements. I am basically a VC++
programmer.
--
Thanks
AnilG
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> As long as both are connected to different segments, yes. That is a windows
> limitation.
> SQL server will listen on all NICs by default so it does not care. The Os
> provides the functionality. The bigger challenge is to get your DNS to
> change quick enough otherwise some users will hit the dead IP.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Anil Gopu" <AnilGopu@.discussions.microsoft.com> wrote in message
> news:1682BC47-4E22-4F24-BEAA-2D8C6A771074@.microsoft.com...
> > Does SQL server supports Cable Redundancy. A system having 2 NIC's for LAN
> > redundancy.
> >
> > --
> > Thanks
> > AnilG
>
>|||Hi,
Segments are networks or part of. You might have one segment with a
192.168.1 ip address and the other with 192.168.2 ip address. If you have
two network card in a machine they can be connected to two network segments.
The issue you raised is a Windows issue and depends on how you setup the
cards
kind regards
Greg O
Need to document your databases. Use the first and still the best AGS SQL
Scribe
http://www.ag-software.com
"Anil Gopu" <AnilGopu@.discussions.microsoft.com> wrote in message
news:AE540719-6953-44B3-9DD5-75099EC2D9FB@.microsoft.com...
> Can I know what is meant by different segements. I am basically a VC++
> programmer.
> --
> Thanks
> AnilG
>
> "Mike Epprecht (SQL MVP)" wrote:
>> Hi
>> As long as both are connected to different segments, yes. That is a
>> windows
>> limitation.
>> SQL server will listen on all NICs by default so it does not care. The Os
>> provides the functionality. The bigger challenge is to get your DNS to
>> change quick enough otherwise some users will hit the dead IP.
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> IM: mike@.epprecht.net
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>> "Anil Gopu" <AnilGopu@.discussions.microsoft.com> wrote in message
>> news:1682BC47-4E22-4F24-BEAA-2D8C6A771074@.microsoft.com...
>> > Does SQL server supports Cable Redundancy. A system having 2 NIC's for
>> > LAN
>> > redundancy.
>> >
>> > --
>> > Thanks
>> > AnilG
>>|||Cable redundancy is working for Win 2003 server when applied a hotfix as
given in KB : http://support.microsoft.com/default.aspx?scid=kb;en-us;817690.
But we facing the same problem in Win XP SP2. Any clues.
--
Thanks
AnilG
"GregO" wrote:
> Hi,
> Segments are networks or part of. You might have one segment with a
> 192.168.1 ip address and the other with 192.168.2 ip address. If you have
> two network card in a machine they can be connected to two network segments.
> The issue you raised is a Windows issue and depends on how you setup the
> cards
>
> --
> kind regards
> Greg O
> Need to document your databases. Use the first and still the best AGS SQL
> Scribe
> http://www.ag-software.com
> "Anil Gopu" <AnilGopu@.discussions.microsoft.com> wrote in message
> news:AE540719-6953-44B3-9DD5-75099EC2D9FB@.microsoft.com...
> > Can I know what is meant by different segements. I am basically a VC++
> > programmer.
> >
> > --
> > Thanks
> > AnilG
> >
> >
> > "Mike Epprecht (SQL MVP)" wrote:
> >
> >> Hi
> >>
> >> As long as both are connected to different segments, yes. That is a
> >> windows
> >> limitation.
> >> SQL server will listen on all NICs by default so it does not care. The Os
> >> provides the functionality. The bigger challenge is to get your DNS to
> >> change quick enough otherwise some users will hit the dead IP.
> >>
> >> Regards
> >> --
> >> Mike Epprecht, Microsoft SQL Server MVP
> >> Zurich, Switzerland
> >>
> >> IM: mike@.epprecht.net
> >>
> >> MVP Program: http://www.microsoft.com/mvp
> >>
> >> Blog: http://www.msmvps.com/epprecht/
> >>
> >> "Anil Gopu" <AnilGopu@.discussions.microsoft.com> wrote in message
> >> news:1682BC47-4E22-4F24-BEAA-2D8C6A771074@.microsoft.com...
> >> > Does SQL server supports Cable Redundancy. A system having 2 NIC's for
> >> > LAN
> >> > redundancy.
> >> >
> >> > --
> >> > Thanks
> >> > AnilG
> >>
> >>
> >>
>
>|||I am also having this same problem. How do you get the DNS to change quick
enough, so that the SQL db Admin's don't call me everytime they can not
connect? I have unchecked the "register this connections address in DNS" and
it still registers the address in DNS. The server that I am having problems
with is also a DNS server. Any suggestions?
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> As long as both are connected to different segments, yes. That is a windows
> limitation.
> SQL server will listen on all NICs by default so it does not care. The Os
> provides the functionality. The bigger challenge is to get your DNS to
> change quick enough otherwise some users will hit the dead IP.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Anil Gopu" <AnilGopu@.discussions.microsoft.com> wrote in message
> news:1682BC47-4E22-4F24-BEAA-2D8C6A771074@.microsoft.com...
> > Does SQL server supports Cable Redundancy. A system having 2 NIC's for LAN
> > redundancy.
> >
> > --
> > Thanks
> > AnilG
>
>

Does SQL Server 2000 Standard Edition does not support SAN ?

Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
protocols by using the Virtual Interface Architecture (VIA), but it doesn't
say explicitly : whether SQL Server 2000 Standard Edition also supports VIA.
So I don't know do I have to buy the Enterprise Edition if I want to use SAN
as the storage area for my SQL 2000 application.
Can anybody help me on it because the Enterprise Edition is much expensive
than the Standard Edition.No, Standard edition does not support SAN. Check
http://www.microsoft.com/sql/evaluation/features/choosing.asp.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>|||To add to Dejan's response, the SAN acronym has 2 completely different
meanings depending on the context. SAN can refer to a Storage Area Network
or a System Area Network. All editions of SQL Server support Storage Area
Networks, which is a common data storage technology. You don't need
Enterprise Edition for this.
However, SQL Server Enterprise Edition is needed to support System Area
Network, which provides a high-speed network communication between different
servers.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>|||Thanks for your reply.
I mean 'Storage Area Network'.
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:ejil$OdNEHA.3052@.TK2MSFTNGP12.phx.gbl...
> To add to Dejan's response, the SAN acronym has 2 completely different
> meanings depending on the context. SAN can refer to a Storage Area
Network
> or a System Area Network. All editions of SQL Server support Storage Area
> Networks, which is a common data storage technology. You don't need
> Enterprise Edition for this.
> However, SQL Server Enterprise Edition is needed to support System Area
> Network, which provides a high-speed network communication between
different
> servers.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c7kl9m$1i61212@.imsp212.netvigator.com...
> > Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> > protocols by using the Virtual Interface Architecture (VIA), but it
> doesn't
> > say explicitly : whether SQL Server 2000 Standard Edition also supports
> VIA.
> > So I don't know do I have to buy the Enterprise Edition if I want to use
> SAN
> > as the storage area for my SQL 2000 application.
> > Can anybody help me on it because the Enterprise Edition is much
expensive
> > than the Standard Edition.
> >
> >
>

Does SQL Server 2000 Standard Edition does not support SAN ?

Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
protocols by using the Virtual Interface Architecture (VIA), but it doesn't
say explicitly : whether SQL Server 2000 Standard Edition also supports VIA.
So I don't know do I have to buy the Enterprise Edition if I want to use SAN
as the storage area for my SQL 2000 application.
Can anybody help me on it because the Enterprise Edition is much expensive
than the Standard Edition.
No, Standard edition does not support SAN. Check
http://www.microsoft.com/sql/evaluat.../choosing.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>
|||To add to Dejan's response, the SAN acronym has 2 completely different
meanings depending on the context. SAN can refer to a Storage Area Network
or a System Area Network. All editions of SQL Server support Storage Area
Networks, which is a common data storage technology. You don't need
Enterprise Edition for this.
However, SQL Server Enterprise Edition is needed to support System Area
Network, which provides a high-speed network communication between different
servers.
Hope this helps.
Dan Guzman
SQL Server MVP
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>
|||Thanks for your reply.
I mean 'Storage Area Network'.
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:ejil$OdNEHA.3052@.TK2MSFTNGP12.phx.gbl...
> To add to Dejan's response, the SAN acronym has 2 completely different
> meanings depending on the context. SAN can refer to a Storage Area
Network
> or a System Area Network. All editions of SQL Server support Storage Area
> Networks, which is a common data storage technology. You don't need
> Enterprise Edition for this.
> However, SQL Server Enterprise Edition is needed to support System Area
> Network, which provides a high-speed network communication between
different[vbcol=seagreen]
> servers.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c7kl9m$1i61212@.imsp212.netvigator.com...
> doesn't
> VIA.
> SAN
expensive
>
sql

Does SQL Server 2000 Standard Edition does not support SAN ?

Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
protocols by using the Virtual Interface Architecture (VIA), but it doesn't
say explicitly : whether SQL Server 2000 Standard Edition also supports VIA.
So I don't know do I have to buy the Enterprise Edition if I want to use SAN
as the storage area for my SQL 2000 application.
Can anybody help me on it because the Enterprise Edition is much expensive
than the Standard Edition.No, Standard edition does not support SAN. Check
http://www.microsoft.com/sql/evalua...s/choosing.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>|||To add to Dejan's response, the SAN acronym has 2 completely different
meanings depending on the context. SAN can refer to a Storage Area Network
or a System Area Network. All editions of SQL Server support Storage Area
Networks, which is a common data storage technology. You don't need
Enterprise Edition for this.
However, SQL Server Enterprise Edition is needed to support System Area
Network, which provides a high-speed network communication between different
servers.
Hope this helps.
Dan Guzman
SQL Server MVP
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>|||Thanks for your reply.
I mean 'Storage Area Network'.
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:ejil$OdNEHA.3052@.TK2MSFTNGP12.phx.gbl...
> To add to Dejan's response, the SAN acronym has 2 completely different
> meanings depending on the context. SAN can refer to a Storage Area
Network
> or a System Area Network. All editions of SQL Server support Storage Area
> Networks, which is a common data storage technology. You don't need
> Enterprise Edition for this.
> However, SQL Server Enterprise Edition is needed to support System Area
> Network, which provides a high-speed network communication between
different
> servers.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c7kl9m$1i61212@.imsp212.netvigator.com...
> doesn't
> VIA.
> SAN
expensive[vbcol=seagreen]
>

Does full text indexing works on unicode field?

Hi all,
Does full text indexing supports searching on a unicode field, for
example, a field that stores chinese characters?
Thank you in advance.Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"alvinyyt" <alvinyyt@.gmail.com> wrote in message
news:1144720305.221875.221920@.e56g2000cwe.googlegroups.com...
> Hi all,
> Does full text indexing supports searching on a unicode field, for
> example, a field that stores chinese characters?
> Thank you in advance.
>|||Yes, make sure you select the appropriate language word breaker.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"alvinyyt" <alvinyyt@.gmail.com> wrote in message
news:1144720305.221875.221920@.e56g2000cwe.googlegroups.com...
> Hi all,
> Does full text indexing supports searching on a unicode field, for
> example, a field that stores chinese characters?
> Thank you in advance.
>