Re: Data Type Question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Louis Davidson (dr_dontspamme_sql_at_hotmail.com)
Date: 01/31/05 

Date: Mon, 31 Jan 2005 11:28:54 -0600

> it was MySQL at first, but apparently there are more systems out there
> where data integrity doesn't matter.
>

:) 

-- 
----------------------------------------------------------------------------
Louis Davidson - drsql@hotmail.com
SQL Server MVP
Compass Technology Management - www.compass.net
Pro SQL Server 2000 Database Design - 
http://www.apress.com/book/bookDisplay.html?bID=266
Note: Please reply to the newsgroups only unless you are interested in 
consulting services.  All other replies may be ignored :)
"Jacco Schalkwijk" <jacco.please.reply@to.newsgroups.mvps.org.invalid> wrote 
in message news:O1lGyd7BFHA.3592@TK2MSFTNGP11.phx.gbl...
> Nope, the issue is not with SQL Server 2000. PositiveInt_Type is not a 
> native datatype in SQL Server 2000.
>
> Do you use any third party software which uses the PositiveInt_Type data 
> type?
>
> (Storing the maximum value allowed when the value that is inserted is 
> greater than the maximum value allowed (i.e. store 99,999 instead of 
> 125,000) is one of those nice "features" of MySQL. That's why I thought 
> that it was MySQL at first, but apparently there are more systems out 
> there where data integrity doesn't matter.
>
> -- 
> Jacco Schalkwijk
> SQL Server MVP
>
>
> "Joe Williams" <joe@anywhere.com> wrote in message 
> news:upKOl76BFHA.1296@TK2MSFTNGP10.phx.gbl...
>>
>> This is Microsoft SQL Server - SQL 2000
>>
>>
>> "Jacco Schalkwijk" <jacco.please.reply@to.newsgroups.mvps.org.invalid> 
>> wrote in message news:udIW156BFHA.2568@TK2MSFTNGP11.phx.gbl...
>>> Try a MySQL newsgroup for MySQL questions. You will have more chance of 
>>> a quick and correct answer. This is a newsgroup dedicated to Microsoft 
>>> SQL Server.
>>>
>>> -- 
>>> Jacco Schalkwijk
>>> SQL Server MVP
>>>
>>>
>>> "Joe Williams" <joe@anywhere.com> wrote in message 
>>> news:eFgaSy6BFHA.1260@TK2MSFTNGP12.phx.gbl...
>>>>i have a table with an integer field that is of type PositiveInt_Type 
>>>>with a length of  4. I am having a problem where when alarger integer 
>>>>tries to get stored (let's say 125,000), it shows up in the database as 
>>>>99,999.
>>>>
>>>> What datatype and length should I be using for an integer that could be 
>>>> up to 1,000,000 in length?
>>>>
>>>> Thanks
>>>>
>>>> Joe
>>>>
>>>
>>>
>>
>>
>
>

Relevant Pages

  • Re: SQL server vs mySQL ???
    ... SQL Server has the broadest range of tools and support utilities of any database system on the planet--by far. ... MS SQL versus MySQL? ... As of 5.0, MySQL finally supports stored procedures, so they are very similar there (you can genericize your data access a bit due to sprocs in both). ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Transfer LARGE DB from MySQL to SQL Server 2K5 problems
    ... newsgroups are managed (and making that a selling point for MSDN ... forums, which, needless to say, drives me away from the MS web sites, and is ... I am going through the MySQL ODBC v3.51 driver, ... streaming across the wire to my SQL Server box. ...
    (microsoft.public.sqlserver.dts)
  • Re: Newbie, True and False
    ... All commands, Insert, Update etc work fine with MySql, but not with MsSql. ... First time working on an SQL database. ... will need to relearn when using sql server. ...
    (microsoft.public.sqlserver.clients)
  • Re: Access 2007 and MySQL
    ... Anyone tried MySQL as backend for recent Acc2k7 FE developments? ... You can however if you want choose SQL server for your back end and then you ... For the most part most your recordset code and most queries should work as ... Set rstRecords = CurrentDb.OpenRecordset ...
    (comp.databases.ms-access)
  • Re: SQL server vs mySQL ???
    ... The easiest way to support multiple databases is to work with a data access ... This question changes depending on which version of MySQL one has. ... * SQL Server has richer trigger support ...
    (microsoft.public.dotnet.framework.adonet)