From: aurelien dot lequoy at gmail dot com Operating system: Linux / Debian 6.01 PHP version: 5.3.18 Package: MSSQL related Bug Type: Bug Bug description:mssql_field_name => filed truncated to 30 chars
Description: ------------ --- >From manual page: http://www.php.net/function.mssql-field-name#refsect1- function.mssql-field-name-seealso --- Still only returns 1st 30 characters of fieldname, I thought this issue was fixed. solution ? : (quick fix) SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='ARKA_PIV_BIZFILE_FULL' order by ORDINAL_POSITION Test script: --------------- set a filed name > 30 chars, make a query and use mssql_field_name to get the field name CREATE TABLE dbo.[ARKA_PIV_BIZFILE_FULL] ( LegacySystem nvarchar(10) null, Subsidiary nvarchar(25) null, LogoName nvarchar(150) null, AccountRef nvarchar(25) null, Account_name nvarchar(150) null, AccountCreationDate nvarchar(100) null, [Customer TimeZone] nvarchar(100) null, Currency nvarchar(10) null, LastYear_Revenue nvarchar(10) null, Current_Revenue nvarchar(10) null, NbAccess nvarchar(10) null, Is_prospect nvarchar(10) null, AccountStatus nvarchar(10) null, BizFileStatus nvarchar(10) null, Comment nvarchar(10) null, RecordCreationDate nvarchar(20) null, RecordLastModificationDate nvarchar(20) null, RecordLastModifierUserLogin nvarchar(10) null, Line_in_error nvarchar(10) null, Line_error_comment nvarchar(10) null, Subscription_start_date nvarchar(20) null, Subscription_end_date nvarchar(20) null, Subscribed_offer_name nvarchar(10) null, isCloud nvarchar(10) null, Event nvarchar(25) null, Anytime nvarchar(10) null, Anywhere nvarchar(10) null, WebEx nvarchar(25) null, WebCast nvarchar(10) null, isVidyo nvarchar(10) null, GlobalCommitmentAmount nvarchar(10) null, GlobalCommitmentPeriod nvarchar(10) null, OtherFlatRecurringCharge nvarchar(10) null, Anywhere_NH_nbr_of_Licenses nvarchar(10) null, Anywhere_NH_Per_License_Price nvarchar(10) null, AnyWhere_NH_PriceType nvarchar(10) null, AnyWhere_NH_Threshold_Min nvarchar(10) null, AnyWhere_NH_Threshold_Max nvarchar(10) null, AnyWhere_NH_RoomSize nvarchar(10) null, AnyWhere_OverageType nvarchar(10) null, AnyWhere_Overage_Price nvarchar(10) null, WebEx_MeetingCenter nvarchar(10) null, WebEx_EventCenter nvarchar(10) null, WebEx_SupportCenter nvarchar(10) null, WebEx_TrainingCenter nvarchar(10) null, WebEx_MicroSite nvarchar(10) null, WebEx_Admin_Login nvarchar(10) null, WebEx_Admin_PWD nvarchar(10) null, Webex_NH_nbr_of_Licenses nvarchar(10) null, WebEx_NH_PriceType nvarchar(10) null, Webex_NH_Per_License_Price nvarchar(10) null, Webex_NH_Per_License_Threshold_Min nvarchar(10) null, Webex_NH_Per_License_Threshold_Max nvarchar(10) null, WebEx_CP_nbr_of_Licenses nvarchar(10) null, WebEx_CP_PriceType nvarchar(10) null, WebEx_CP_License_Price nvarchar(10) null, WebEx_CP_Threshold_Min nvarchar(10) null, WebEx_CP_Threshold_Max nvarchar(10) null, WebEx_RoomSize nvarchar(10) null, WebEx_Overage_Type nvarchar(10) null, WebEx_Overage_Price nvarchar(10) null, BandDiscount1_BandName nvarchar(10) null, BandDiscount1_MinuteThreshold_Min_1 nvarchar(10) null, BandDiscount1_MinuteThreshold_Max_1 nvarchar(10) null, BandDiscount1_DiscountPercentage_1 nvarchar(10) null, BandDiscount1_MinuteThreshold_Min_2 nvarchar(10) null, BandDiscount1_MinuteThreshold_Max_2 nvarchar(10) null, BandDiscount1_DiscountPercentage_2 nvarchar(10) null, BandDiscount1_MinuteThreshold_Min_3 nvarchar(10) null, BandDiscount1_MinuteThreshold_Max_3 nvarchar(10) null, BandDiscount1_DiscountPercentage_3 nvarchar(10) null, BandDiscount2_BandName nvarchar(10) null, BandDiscount2_MinuteThreshold_Min_1 nvarchar(10) null, BandDiscount2_MinuteThreshold_Max_1 nvarchar(10) null, BandDiscount2_DiscountPercentage_1 nvarchar(10) null, BandDiscount2_MinuteThreshold_Min_2 nvarchar(10) null, BandDiscount2_MinuteThreshold_Max_2 nvarchar(10) null, BandDiscount2_DiscountPercentage_2 nvarchar(10) null, BandDiscount2_MinuteThreshold_Min_3 nvarchar(10) null, BandDiscount2_MinuteThreshold_Max_3 nvarchar(10) null, BandDiscount2_DiscountPercentage_3 nvarchar(10) null, VolumeDiscount_Threshold_Metric nvarchar(10) null, VolumeDiscount_Threshold_Min_1 nvarchar(10) null, VolumeDiscount_Threshold_Max_1 nvarchar(10) null, VolumeDiscount_DiscountPercentage_1 nvarchar(10) null, VolumeDiscount_Threshold_Min_2 nvarchar(10) null, VolumeDiscount_Threshold_Max_2 nvarchar(10) null, VolumeDiscount_DiscountPercentage_2 nvarchar(10) null, VolumeDiscount_Threshold_Min_3 nvarchar(10) null, VolumeDiscount_Threshold_Max_3 nvarchar(10) null, VolumeDiscount_DiscountPercentage_3 nvarchar(10) null, VolumeDiscount_Threshold_Min_4 nvarchar(10) null, VolumeDiscount_Threshold_Max_4 nvarchar(10) null, VolumeDiscount_DiscountPercentage_4 nvarchar(10) null, Is_FlatDiscount_with_condition nvarchar(10) null, Flat_Discount_condition nvarchar(10) null, Flat_Discount_Threshold nvarchar(10) null, Flat_discountAmount nvarchar(10) null, EventId nvarchar(10) null, EventStatus nvarchar(10) null, Event_ExpectedEventStartDate nvarchar(20) null, Event_ExpectedEventEndDate nvarchar(20) null, Event_ExpectedDuration nvarchar(10) null, Event_ScheduledNumberOfAttendees nvarchar(10) null, Event_EffectiveNumberOfAttendees nvarchar(10) null, Event_SetupRate nvarchar(10) null, Event_minimumFee nvarchar(10) null, Event_CancellationRate_24H nvarchar(10) null, Event_CancellationRate_48H nvarchar(10) null, Event_CancellationRate_NoShow nvarchar(10) null, PEvent_basic_price nvarchar(10) null, PEvent_included_minutes nvarchar(10) null, PEvent_blockSizeOfAdditionalMinutes nvarchar(10) null, PEvent_pricePerAdditionalBlockOfMinutes nvarchar(10) null, BT_Salutation nvarchar(20) null, BT_Name1 nvarchar(200) null, BT_Name2 nvarchar(200) null, BT_FirstName nvarchar(200) null, BT_MiddleInitial nvarchar(10) null, BT_LastName nvarchar(200) null, BT_Email nvarchar(200) null, BT_Address1 nvarchar(200) null, BT_Address2 nvarchar(200) null, BT_Address3 nvarchar(200) null, BT_City nvarchar(200) null, BT_State nvarchar(200) null, BT_Zip nvarchar(50) null, BT_Country nvarchar(50) null, BT_LocalSalutation nvarchar(20) null, BT_LocalFirstName nvarchar(200) null, BT_LocalMiddleInitial nvarchar(20) null, BT_LocalLastName nvarchar(200) null, BT_LocalAddress1 nvarchar(200) null, BT_LocalAddress2 nvarchar(200) null, BT_LocalAddress3 nvarchar(200) null, BT_LocalCity nvarchar(200) null, BT_LocalState nvarchar(200) null, ST_Salutation nvarchar(20) null, ST_Name1 nvarchar(200) null, ST_Name2 nvarchar(200) null, ST_FirstName nvarchar(200) null, ST_MiddleInitial nvarchar(10) null, ST_LastName nvarchar(200) null, ST_Email nvarchar(200)null , ST_Address1 nvarchar(200) null, ST_Address2 nvarchar(200) null, ST_Address3 nvarchar(200) null, ST_City nvarchar(200) null, ST_State nvarchar(200) null, ST_Zip nvarchar(50) null, ST_Country nvarchar(50) null, ST_LocalSalutation nvarchar(20) null, ST_LocalFirstName nvarchar(200) null, ST_LocalMiddleInitial nvarchar(20) null, ST_LocalLastName nvarchar(200) null, ST_LocalAddress1 nvarchar(200) null, ST_LocalAddress2 nvarchar(200) null, ST_LocalAddress3 nvarchar(200) null, ST_LocalCity nvarchar(200) null, ST_LocalState nvarchar(200) null, BT_County nvarchar(50) null, BT_LocalCounty nvarchar(50) null, ST_County nvarchar(50) null, ST_LocalCounty nvarchar(50) null ) ON [PRIMARY] go Expected result: ---------------- LegacySystem Subsidiary LogoName AccountRef Account_name AccountCreationDate Customer TimeZone Currency LastYear_Revenue Current_Revenue NbAccess Is_prospect AccountStatus BizFileStatus Comment RecordCreationDate RecordLastModificationDate RecordLastModifierUserLogin Line_in_error Line_error_comment Subscription_start_date Subscription_end_date Subscribed_offer_name isCloud Event Anytime Anywhere WebEx WebCast isVidyo GlobalCommitmentAmount GlobalCommitmentPeriod OtherFlatRecurringCharge Anywhere_NH_nbr_of_Licenses Anywhere_NH_Per_License_Price AnyWhere_NH_PriceType AnyWhere_NH_Threshold_Min AnyWhere_NH_Threshold_Max AnyWhere_NH_RoomSize AnyWhere_OverageType AnyWhere_Overage_Price WebEx_MeetingCenter WebEx_EventCenter WebEx_SupportCenter WebEx_TrainingCenter WebEx_MicroSite WebEx_Admin_Login WebEx_Admin_PWD Webex_NH_nbr_of_Licenses WebEx_NH_PriceType Webex_NH_Per_License_Price Webex_NH_Per_License_Threshold_Min Webex_NH_Per_License_Threshold_Max WebEx_CP_nbr_of_Licenses WebEx_CP_PriceType WebEx_CP_License_Price WebEx_CP_Threshold_Min WebEx_CP_Threshold_Max WebEx_RoomSize WebEx_Overage_Type WebEx_Overage_Price BandDiscount1_BandName BandDiscount1_MinuteThreshold_Min_1 BandDiscount1_MinuteThreshold_Max_1 BandDiscount1_DiscountPercentage_1 BandDiscount1_MinuteThreshold_Min_2 BandDiscount1_MinuteThreshold_Max_2 BandDiscount1_DiscountPercentage_2 BandDiscount1_MinuteThreshold_Min_3 BandDiscount1_MinuteThreshold_Max_3 BandDiscount1_DiscountPercentage_3 BandDiscount2_BandName BandDiscount2_MinuteThreshold_Min_1 BandDiscount2_MinuteThreshold_Max_1 BandDiscount2_DiscountPercentage_1 BandDiscount2_MinuteThreshold_Min_2 BandDiscount2_MinuteThreshold_Max_2 BandDiscount2_DiscountPercentage_2 BandDiscount2_MinuteThreshold_Min_3 BandDiscount2_MinuteThreshold_Max_3 BandDiscount2_DiscountPercentage_3 VolumeDiscount_Threshold_Metric VolumeDiscount_Threshold_Min_1 VolumeDiscount_Threshold_Max_1 VolumeDiscount_DiscountPercentage_1 VolumeDiscount_Threshold_Min_2 VolumeDiscount_Threshold_Max_2 VolumeDiscount_DiscountPercentage_2 VolumeDiscount_Threshold_Min_3 VolumeDiscount_Threshold_Max_3 VolumeDiscount_DiscountPercentage_3 VolumeDiscount_Threshold_Min_4 VolumeDiscount_Threshold_Max_4 VolumeDiscount_DiscountPercentage_4 Is_FlatDiscount_with_condition Flat_Discount_condition Flat_Discount_Threshold Flat_discountAmount EventId EventStatus Event_ExpectedEventStartDate Event_ExpectedEventEndDate Event_ExpectedDuration Event_ScheduledNumberOfAttendees Event_EffectiveNumberOfAttendees Event_SetupRate Event_minimumFee Event_CancellationRate_24H Event_CancellationRate_48H Event_CancellationRate_NoShow PEvent_basic_price PEvent_included_minutes PEvent_blockSizeOfAdditionalMinutes PEvent_pricePerAdditionalBlockOfMinutes BT_Salutation BT_Name1 BT_Name2 BT_FirstName BT_MiddleInitial BT_LastName BT_Email BT_Address1 BT_Address2 BT_Address3 BT_City BT_State BT_Zip BT_Country BT_LocalSalutation BT_LocalFirstName BT_LocalMiddleInitial BT_LocalLastName BT_LocalAddress1 BT_LocalAddress2 BT_LocalAddress3 BT_LocalCity BT_LocalState ST_Salutation ST_Name1 ST_Name2 ST_FirstName ST_MiddleInitial ST_LastName ST_Email ST_Address1 ST_Address2 ST_Address3 ST_City ST_State ST_Zip ST_Country ST_LocalSalutation ST_LocalFirstName ST_LocalMiddleInitial ST_LocalLastName ST_LocalAddress1 ST_LocalAddress2 ST_LocalAddress3 ST_LocalCity ST_LocalState BT_County BT_LocalCounty ST_County ST_LocalCounty Actual result: -------------- LegacySystem Subsidiary LogoName AccountRef Account_name AccountCreationDate Customer TimeZone Currency LastYear_Revenue Current_Revenue NbAccess Is_prospect AccountStatus BizFileStatus Comment RecordCreationDate RecordLastModificationDate RecordLastModifierUserLogin Line_in_error Line_error_comment Subscription_start_date Subscription_end_date Subscribed_offer_name isCloud Event Anytime Anywhere WebEx WebCast isVidyo GlobalCommitmentAmount GlobalCommitmentPeriod OtherFlatRecurringCharge Anywhere_NH_nbr_of_Licenses Anywhere_NH_Per_License_Price AnyWhere_NH_PriceType AnyWhere_NH_Threshold_Min AnyWhere_NH_Threshold_Max AnyWhere_NH_RoomSize AnyWhere_OverageType AnyWhere_Overage_Price WebEx_MeetingCenter WebEx_EventCenter WebEx_SupportCenter WebEx_TrainingCenter WebEx_MicroSite WebEx_Admin_Login WebEx_Admin_PWD Webex_NH_nbr_of_Licenses WebEx_NH_PriceType Webex_NH_Per_License_Price Webex_NH_Per_License_Threshold Webex_NH_Per_License_Threshold WebEx_CP_nbr_of_Licenses WebEx_CP_PriceType WebEx_CP_License_Price WebEx_CP_Threshold_Min WebEx_CP_Threshold_Max WebEx_RoomSize WebEx_Overage_Type WebEx_Overage_Price BandDiscount1_BandName BandDiscount1_MinuteThreshold_ BandDiscount1_MinuteThreshold_ BandDiscount1_DiscountPercenta BandDiscount1_MinuteThreshold_ BandDiscount1_MinuteThreshold_ BandDiscount1_DiscountPercenta BandDiscount1_MinuteThreshold_ BandDiscount1_MinuteThreshold_ BandDiscount1_DiscountPercenta BandDiscount2_BandName BandDiscount2_MinuteThreshold_ BandDiscount2_MinuteThreshold_ BandDiscount2_DiscountPercenta BandDiscount2_MinuteThreshold_ BandDiscount2_MinuteThreshold_ BandDiscount2_DiscountPercenta BandDiscount2_MinuteThreshold_ BandDiscount2_MinuteThreshold_ BandDiscount2_DiscountPercenta VolumeDiscount_Threshold_Metri VolumeDiscount_Threshold_Min_1 VolumeDiscount_Threshold_Max_1 VolumeDiscount_DiscountPercent VolumeDiscount_Threshold_Min_2 VolumeDiscount_Threshold_Max_2 VolumeDiscount_DiscountPercent VolumeDiscount_Threshold_Min_3 VolumeDiscount_Threshold_Max_3 VolumeDiscount_DiscountPercent VolumeDiscount_Threshold_Min_4 VolumeDiscount_Threshold_Max_4 VolumeDiscount_DiscountPercent Is_FlatDiscount_with_condition Flat_Discount_condition Flat_Discount_Threshold Flat_discountAmount EventId EventStatus Event_ExpectedEventStartDate Event_ExpectedEventEndDate Event_ExpectedDuration Event_ScheduledNumberOfAttende Event_EffectiveNumberOfAttende Event_SetupRate Event_minimumFee Event_CancellationRate_24H Event_CancellationRate_48H Event_CancellationRate_NoShow PEvent_basic_price PEvent_included_minutes PEvent_blockSizeOfAdditionalMi PEvent_pricePerAdditionalBlock BT_Salutation BT_Name1 BT_Name2 BT_FirstName BT_MiddleInitial BT_LastName BT_Email BT_Address1 BT_Address2 BT_Address3 BT_City BT_State BT_Zip BT_Country BT_LocalSalutation BT_LocalFirstName BT_LocalMiddleInitial BT_LocalLastName BT_LocalAddress1 BT_LocalAddress2 BT_LocalAddress3 BT_LocalCity BT_LocalState ST_Salutation ST_Name1 ST_Name2 ST_FirstName ST_MiddleInitial ST_LastName ST_Email ST_Address1 ST_Address2 ST_Address3 ST_City ST_State ST_Zip ST_Country ST_LocalSalutation ST_LocalFirstName ST_LocalMiddleInitial ST_LocalLastName ST_LocalAddress1 ST_LocalAddress2 ST_LocalAddress3 ST_LocalCity ST_LocalState BT_County BT_LocalCounty ST_County ST_LocalCounty -- Edit bug report at https://bugs.php.net/bug.php?id=63574&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=63574&r=trysnapshot54 Try a snapshot (PHP 5.3): https://bugs.php.net/fix.php?id=63574&r=trysnapshot53 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=63574&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=63574&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=63574&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=63574&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=63574&r=needscript Try newer version: https://bugs.php.net/fix.php?id=63574&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=63574&r=support Expected behavior: https://bugs.php.net/fix.php?id=63574&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=63574&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=63574&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=63574&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=63574&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=63574&r=dst IIS Stability: https://bugs.php.net/fix.php?id=63574&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=63574&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=63574&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=63574&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=63574&r=mysqlcfg