Classpath

Hi everybody

I have been trying to compile a servlet. When i try
import javax.servlet.*

I get the compilation error " javax.servlet does not exist"

I have tomcat installed. I understand that i have to make some change in the classpath. I have servlet-api.jar and also jsp-api.jar. But i don't have classpath variable in my environment variables.

Any suggestiions!!!!!!!!!!!!!

thanksYou are totally in a wrong place vmiharia ... We only talk databases here ...

Originally posted by vmiharia
Hi everybody

I have been trying to compile a servlet. When i try
import javax.servlet.*

I get the compilation error " javax.servlet does not exist"

I have tomcat installed. I understand that i have to make some change in the classpath. I have servlet-api.jar and also jsp-api.jar. But i don't have classpath variable in my environment variables.

Any suggestiions!!!!!!!!!!!!!

thankssqlsql

Chinese Language Characters

When I import an excel file to SQL that contains Chineses characters they get
distorted and illegible. How do I get SQL to interpret the characters
properly?
Thank you!
Several things need to happen.
You need to have the language pack installed on the PC. It sounds like you
do because you can see them in Excel.
The second thing you need to do is to use the nchar, nvarchar and ntext data
types when you create your tables. These are the national character sets
and allow for other language use.
If that doesn't work, ensure that you are using the appropriate collation
when you create your objects. You can set a collation for an entire
database, a table, or individual columns.
HTH
Rick Sawtell
MCT, MCSD, MCDBA
"JuJu" <JuJu@.discussions.microsoft.com> wrote in message
news:E29BAD1F-8790-4D55-9AFA-301034186BB8@.microsoft.com...
> When I import an excel file to SQL that contains Chineses characters they
get
> distorted and illegible. How do I get SQL to interpret the characters
> properly?
> Thank you!

Chinese Language Characters

When I import an excel file to SQL that contains Chineses characters they get
distorted and illegible. How do I get SQL to interpret the characters
properly?
Thank you!Several things need to happen.
You need to have the language pack installed on the PC. It sounds like you
do because you can see them in Excel.
The second thing you need to do is to use the nchar, nvarchar and ntext data
types when you create your tables. These are the national character sets
and allow for other language use.
If that doesn't work, ensure that you are using the appropriate collation
when you create your objects. You can set a collation for an entire
database, a table, or individual columns.
HTH
Rick Sawtell
MCT, MCSD, MCDBA
"JuJu" <JuJu@.discussions.microsoft.com> wrote in message
news:E29BAD1F-8790-4D55-9AFA-301034186BB8@.microsoft.com...
> When I import an excel file to SQL that contains Chineses characters they
get
> distorted and illegible. How do I get SQL to interpret the characters
> properly?
> Thank you!

checking a CSV file

Hi,

I'm trying to import some data from a CSV file into a table in SQL server. At around row 40.000 SQL server gives an error. It says: Column delimiter not found. I think that there went something wrong creating the CSV file. I thought of just opening the CSV file en checking it by hand but it is to big to open. Does anyone know if there i a way to check a CSV file with a program or something?

JoachimYou can try using MS Access. Create the same table etc. Try importing your csv again and it should discard any invalids rows. Or try and achieve that with a DTS job