Topic profile page for Data type.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Data type.
Topic "Data type" was discussed 11,801 times on 630 sites in last 3 months
has yet to find a compelling reason to use the... has yet to find a compelling reason to use the "float" data type. Why one would need "approximate" numbers in an app is beyond me. 1:58 PM Aug 26th from web
Started 1 day ago (2009-11-28 01:09:00)
by Matt7121
When I use HealthVault Explorer to create a new lab test result, I can set the Status to Pending or Complete and have that status show up in the table of test results. However, if I create a LabTestResults object in code and then send it to HealthVault through my web application, the status doesn't show up in the table (though it does show up in the Details panel if I click on the row). If I ...
Started 1 day, 15 hours ago (2009-11-27 09:36:00)
by Roquero
Hi, I have stored a GeometryCollection (of LineStrings) in the database, and I have confirmed with STAsText() on the database field that it is really a GeometryCollection. Since we use datasets we have to convert the sqlgeometry to byte[] in the data layer. When I try to convert the byte[] back to SqlGeometry with STGeomFromWKB the method interpret the byte[] as MultiLineString instead of ...
Started 1 day, 18 hours ago (2009-11-27 06:56:00)
by mahendra dubey
Hi There I m using sql server. I have a column Name nvarchar(max) in table.Now I want to change datatype nvarchar(max) to nvarchar(4000).Will the data be truncated automatically? if 'Yes',How data will be truncated. i.e. from left ,from right or any part. Is this truncation depends on Sql server version also? Awaiting Your response
Started 1 day, 20 hours ago (2009-11-27 05:05:00)
by Russell Mangel
Hi, I am using VS2008/VS2010(Beta) C# and SQL Server 2008. What is the cleanest way to map SQL types to CLR types, and vice versa. Example: varchar -> System.String int-> System.Int32 Is there a SQL server table that has the mapping from SQL to CLR types? Is there an enum that matches the SQL sys.types table? Currently I am reading the SQL user_type_id using a data reader, then I use a C# ...
Started 2 days, 3 hours ago (2009-11-26 21:41:00)
by Russell Mangel
Hi, I am using VS2008/VS2010(Beta) C# and SQL Server 2008. What is the cleanest way to map SQL types to CLR types, and vice versa. Example: varchar -> System.String int-> System.Int32 Is there a SQL server table that has the mapping from SQL to CLR types? Is there an enum that matches the SQL sys.types table...
Started 2 days, 7 hours ago (2009-11-26 18:02:00)
by shapper
Hello, I am saving latitude and longitude values on a database for use with Google Maps. For example: Latitude = 44.797916 Longitude = -93.278046 What SQL data type should I use to hold these values? Thanks, Miguel
Started 2 days, 14 hours ago (2009-11-26 10:36:00)
by shapper
Hello, I am saving latitude and longitude values on a database for use with Google Maps. For example: Latitude = 44.797916 Longitude = -93.278046 What SQL data type should I use to hold these values? Thanks, Miguel .
Started 4 days, 1 hour ago (2009-11-24 23:31:00)
by frontier007
All, I am not aware of using BFILE datatype. Need your help on this.... I have created one table. Below is the description: create table test_bfile ( file_id number, file_pic bfile) Then inserted two records in it. insert into test_bfile values(3,bfilename('C:\','images1.jpg')); insert into test_bfile values(3,bfilename('C:\','images2....
Started 4 days, 2 hours ago (2009-11-24 22:36:00)
by Maxx_Thai
Dear All, I upgraded Maximo system from 4.1.1 to 7.1 on Sql Server 2008 Database and WebSphere 6.1 . Once we completed the upgrade process, we can start and work with Maximo 7.1 in other Applications like Asset, Location, PR, PO, Work Order ect . But for Database Configuration App, when I try to insert new object it show error 'BMXZZ2000E - Not a valid data type.' . Do any ...
Started 4 days, 10 hours ago (2009-11-24 14:46:00)
by Enigmachrysalis
"Data type mismatch in criteria expression" Run-time error '-2147217913 (80040e07)' This is the error I get at the bold blue code below, I am assuming there is some error in the SQL statement since the code I lifted it from works fine, except there are no leading zeros for the number that code uses. I can post that as well if the...
Started 1 week, 1 day ago (2009-11-20 07:29:00)
by shreyasbhagat
Hi All, I have date dimension which has a data type as Wchar in Cube and the Dimension member value as [Saabel Opportunity].[Opportunity Closed Date].[Opportunity Closed Date].&[1998-11-24T00:00:00] I want to convert this value to Date Type Hence i have written below query but this is giving me some error as Type Mismatch. WITH MEMBER [MEASURES...
Started 1 week, 1 day ago (2009-11-20 12:51:00)
by iMoon
Hello Experts I am looking for some help explanation for the following output I see... 6271036284597753617L/33 = 190031402563568291 And so 190031402563568291*33 should be 62710362845977_53617_L But its gives :62710362845977_53603_ This is how I am printing it ,see diff values !! System.out.println(6271036284597753617L/33); System.out.println((...
Started 5 days, 5 hours ago (2009-11-23 19:55:00)
by nikh
Hello People, I am new to java, i need some help with data type conversion: I have variable(string) storing IP Address IPAddr="10.10.103.10" I have to call a library function which passes IP Address and does something and returns me a value. The problem I have is that external function call in this library excepts IP Address in form of a byte array. Here is the syntax for the ...
Started 5 days, 2 hours ago (2009-11-23 22:58:00)
by Enigmachrysalis
Run-time error '-2147217913 (80040e07)' This is the error I get at the bold blue code below, I am assuming there is some error in the SQL statement since the code I lifted it from works fine, except there are no leading zeros for the number that code uses. I can post that as well if the answer is not obvious. The "ID" field is a text field in Access by the by. Excuse me if this is ...
Started 5 days, 14 hours ago (2009-11-23 11:07:00)
by Selvaraj M
I got the below error while configureing the application in Admin Console. Please guide me . Could not store transport type data for primary Transport of send Port 'SendPort_SendDeclinePort_Latest' to config store.Primary SSO server '' failed.Could not contact the SSo server ''.Check that SSO is configured and that the SSO service is running on that server (Microsoft.Biztalk....
Started 1 week ago (2009-11-21 08:37:00)
by lanhj001
Hello I need to set up my own data type as one part of my college project. The code in this first post is up to date with my current problem in the code so that you don't need to scroll through posts to see where I'm at. Overview of what I want the code to do: The data type I'm trying to set up will be called class2. The name of that attribute that will be using it is ...
Started 4 days, 6 hours ago (2009-11-24 18:59:00)
by ferrethouse
> My stored procedure is failing because I'm doing an exec on @SQL variable which is a varchar(8000) but the actual SQL is getting chopped off because it is longer than 8000 characters. It complains when I try to use a TEXT data type instead. Here is the code... SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER procedure [dbo].[dynamic_pivot] ( @select ...
Started 2 days, 23 hours ago (2009-11-26 01:27:00)
by madhivanan
> quote: I printed out this line... select @pivot=coalesce(@pivot+',','')+'['+pivot_column+'] 'from #pivot_columns And it is getting truncated which I believe is causing the error. That may not be true. You should see the actual length by print len(@pivot) Madhivanan Failing to plan is Planning to fail
Started 5 days, 21 hours ago (2009-11-23 03:27:00)
by AamirKhan
Microsoft Visual Studio 2005 code is given below. I am not using Visual Studio because of some circumstances (as i mentioned before): (Only serial code is included not whole) The code below might help in converting it to VB6 (the difference is that it uses polling and i had done interrupt as i have to include some other code in future too.) receive(i, j) = serialportx.ReadByte() ' ...
Started 3 days, 9 hours ago (2009-11-25 16:13:00)
by mzu
I like your point about conversion. Suprisingly enough, if you substitute device name by visa resource name or similar, it works as it should. It is also strange that the data type of the value is string an not DaqMx device. But about the race condition: Dennis, who is performing the write in the original vi? Or what is your definition of the race condition? The one I am accustomed ...
