Post reply

Text in Access is nvarchar in SQL!??!??

  • February 9, 2004 at 12:54 pm

    #65014

    Hello!

    Text in access is automaticly nText in SQL when I use Upsize Wizard from access. HOw can I change it to varchar instead of nvarchar? Is this an option in access or SQL?

    - Thanks


    -Lars

    Please only reply to this newsgroup. All mails would be bounced back.

  • February 10, 2004 at 5:05 am

    #493355

    My ritual when moving Access tables to SQL Server is to first run the import wizard in SQL Server.  Then using Enterprise Manager I write the SQL for the tables.  I open the SQL file, do a find replace nvarchar -> varchar, ntext -> text.

    I may also change varchar(x) -> char(x) for x < 5.

    Then I import the data.

    Russel Loski, MCSD

    Russel Loski, MCSE Business Intelligence, Data Platform

  • February 12, 2004 at 11:49 pm

    #493944

    RLoski 

    I think u have to change the date/time fields as well.

     




    My Blog: http://dineshasanka.spaces.live.com/

  • February 13, 2004 at 1:32 am

    #493954

    When using the import Wizard in SQL server - you don't have any of the PK and IX transferred. At least this is what I have seen. Am I correct?

     

    Why do you change varchar to char if varchar is larger than 5?


    -Lars

    Please only reply to this newsgroup. All mails would be bounced back.

  • February 13, 2004 at 1:32 am

    #493953

    When using the import Wizard in SQL server - you don't have any of the PK and IX transferred. At least this is what I have seen. Am I correct?

     

    Why do you change varchar to char if varchar is larger than 5?


    -Lars

    Please only reply to this newsgroup. All mails would be bounced back.

  • February 13, 2004 at 1:32 am

    #493952

    When using the import Wizard in SQL server - you don't have any of the PK and IX transferred. At least this is what I have seen. Am I correct?

     

    Why do you change varchar to char if varchar is larger than 5?


    -Lars

    Please only reply to this newsgroup. All mails would be bounced back.

  • February 13, 2004 at 1:32 am

    #493951

    When using the import Wizard in SQL server - you don't have any of the PK and IX transferred. At least this is what I have seen. Am I correct?

     

    Why do you change varchar to char if varchar is larger than 5?


    -Lars

    Please only reply to this newsgroup. All mails would be bounced back.

  • February 13, 2004 at 6:29 am

    #493971

    Actually what I mean by x < 5 is that if the varchar is less than 5 I convert to char.  My rationale for that is that a varchar takes a minimum of 4 characters even if null (it may be a larger than that).  A char(3) takes three bytes of space.

    Russ

    Russel Loski, MCSE Business Intelligence, Data Platform

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply