[GitHub] spark issue #13944: [SPARK-16297][SQL] Fix mapping Microsoft SQLServer diale...

[meknio <gi...@git.apache.org>]

Github user meknio commented on the issue:

    https://github.com/apache/spark/pull/13944
  
    the problem is if it is run with no fix throws an exception and causes the following error:
    -"Cannot specify a column width on data type bit."
    
    The problem stems from the fact that the "java.sql.types.BIT" type is mapped as BIT[n] that really must be mapped as BIT.
    This concerns the type Boolean.
    
    As for the type String with maximum length of characters it must be mapped as VARCHAR (MAX) instead of TEXT which is a type deprecated in SQLServer.
    
    Here is the list of mappings for SQL Server:
    https://msdn.microsoft.com/en-us/library/ms378878(v=sql.110).aspx



---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org